INF_CV_TODATES
Back to current versionRestore this version

Alias: IVPTD#

(INF_CV_TODATES)
Todate Headers

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
UNIT_CODEVarchar2(16)CODEY
GROUP_CODEVarchar2(16)CODEY
COUNTRY_CODEVarchar2(16)CODEY
STATE_PROVINCE_CODE_HOMEVarchar2(16)CODE
STATE_PROVINCE_CODE_WORKVarchar2(16)CODE
TODATE_TYPEVarchar2(30)VARCHAR30Y
CALENDAR_PERIODNumber(10)NUMBER10
SCHOOL_DISTRICT_CODEVarchar2(16)CODE
GEO_CODE_WORKVarchar2(16)CODE
GEO_CODE_HOMEVarchar2(16)CODE
PC_CODENumber(4)CODE NUMERIC
AMOUNTNumber(18)AMT12V6
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30