Alias: IVTTP#

(INF_CV_TEAMPOSTS)

Team Post Details

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)Y
WORK_DIVISION_CODEVarchar2(16)Y
WORK_AREA_CODEVarchar2(16)Y
WORK_STATION_CODEVarchar2(16)Y
WORK_TEAM_CODEVarchar2(16)Y
START_DATEDate()Y
UNIT_CODEVarchar2(16)
JOB_CODEVarchar2(16)
DEPARTMENT_CODEVarchar2(16)
STATION_POST_RANKNumber(5)Y
ACTING_TEAM_LEADERVarchar2(4)
SCHEDULE_METHODVarchar2(30)
RELATIVE_START_DAYNumber(5)
EFFECTIVEDate()
EXPIRYDate()
CHANGE_CODEVarchar2(16)
ASSIGNED_WSENumber(5)
START_TIMENumber(5)
PERSON_CODEVarchar2(16)
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
ASSIGNMENT_START_DATEDate()
ASSIGNMENT_CODEVarchar2(16)
SHIFT_PATTERN_CODEVarchar2(16)
SHIFT_PATTERN_START_DATEDate()
COST_CENTER_CODEVarchar2(16)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


Notes #

Click to create a new notes page