INF_CV_POSTINGS
Back to current versionRestore this version

Alias: IVRPO#

(INF_CV_POSTINGS)
Postings

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
POSTING_CODEVarchar2(16)CODEY
JOB_PROFILE_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30Y
HIRE_DATEDate()DATEY
ASSIGNMENT_CODEVarchar2(16)CODEY
ASSIGNMENT_START_DATEDate()DATEY
POSTING_TITLEVarchar2(50)DESCRIPTIONY
POSTING_STATUSVarchar2(30)VARCHAR30Y
DEPARTMENT_CODEVarchar2(16)CODE
LOCATION_CODEVarchar2(16)CODE
UNIT_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
RANGE_CODEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
RECRUITER_CODEVarchar2(16)CODE
APPROVEDVarchar2(4)VARCHAR4
POSTING_SOURCEVarchar2(30)VARCHAR30
POSTING_TYPEVarchar2(30)VARCHAR30
POSTING_CATEGORYVarchar2(30)VARCHAR30
POSTING_PRIORITYVarchar2(30)VARCHAR30
REQUIRED_FTENumber(9)AMT5V4
DEFAULT_FTENumber(9)AMT5V4
FILLED_FTENumber(9)AMT5V4
REQUISITION_DATEDate()DATE
INTERNAL_POSTING_OPENEDDate()DATE
GENERAL_POSTING_OPENEDDate()DATE
POSTING_CLOSEDDate()DATE
POSTING_FILLEDDate()DATE
POSTING_EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
GROUP_TYPEVarchar2(30)VARCHAR30
RESPONSIBILITY_LEVELVarchar2(30)VARCHAR30
LANGUAGE_CLASSVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
WORK_TYPEVarchar2(30)VARCHAR30
POSTING_ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_END_DATEDate()DATE
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation