back to wuv views

ColumnTypeLengthContents
CtIDint Code table ID
CtTypechar6Code type
Code1char12Valid codes for CtType (e.g. for CtType=ADVIS, FYA=four-year advisor; for CtType=CC, ET=Ethiopia; etc.)
EffDtdatetime Beginning date that the code is valid
EndDtdatetime Ending date the the code is valid
RestrictFlagchar1Restrict flag (N=no, Y=yes)
Code2char12Second valid code
Code3char12Third valid code
CodeValuevarchar40Code value (e.g. for CtType=ADVIS and Code1=FYA, CodeValue=Four Year Advisor)
DefaultValuechar12Default value
MaintDtdatetime Last date record was updated
LastChgNamechar45Name of last user who updated the record