INF_CV_TEAMPOSTS
Back to current versionRestore this version

Alias: IVTTP#

(INF_CV_TEAMPOSTS)
Team Post Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
WORK_DIVISION_CODEVarchar2(16)CODEY
WORK_AREA_CODEVarchar2(16)CODEY
WORK_STATION_CODEVarchar2(16)CODEY
WORK_TEAM_CODEVarchar2(16)CODEY
START_DATEDate()DATEY
UNIT_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODE
STATION_POST_RANKNumber(5)NUMBER5Y
ACTING_TEAM_LEADERVarchar2(4)VARCHAR4
SCHEDULE_METHODVarchar2(30)VARCHAR30
RELATIVE_START_DAYNumber(5)NUMBER5
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
ASSIGNED_WSENumber(5)NUMBER5
START_TIMENumber(5)NUMBER5
PERSON_CODEVarchar2(16)CODE
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODE
SHIFT_PATTERN_CODEVarchar2(16)CODE
SHIFT_PATTERN_START_DATEDate()DATE
COST_CENTER_CODEVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30