INF_CV_ASSIGNMENTS
Back to current versionRestore this version

Alias: IVEAS#

(INF_CV_ASSIGNMENTS)
Provides all of the details for the Assignment ent

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
ASSIGNMENT_CODEVarchar2(16)CODEY
ASSIGNMENT_TYPEVarchar2(30)VARCHAR30
ASSIGNMENT_STATUSVarchar2(30)VARCHAR30
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_END_DATEDate()DATE
PRIME_ASSIGNMENTVarchar2(4)VARCHAR4
DESCRIPTIONVarchar2(50)DESCRIPTION
NEXT_REVIEW_DATEDate()DATE
TS_SENIORITY_DATEDate()DATE
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRYY
CHANGE_CODEVarchar2(16)CODE
STATUS_CODEVarchar2(16)CODE
POSITION_CODEVarchar2(16)CODE
DEPARTMENT_CODEVarchar2(16)CODE
UNIT_CODEVarchar2(16)CODE
JOB_CODEVarchar2(16)CODE
LOCATION_CODE_WORK_INVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
GROUP_CODEVarchar2(16)CODE
AUTHORIZATION_CODEVarchar2(16)CODE
WORK_RULE_CODEVarchar2(16)CODE
LOCATION_CODE_PAYDESTVarchar2(16)CODE
PERSON_CODE_REPLACED_BYVarchar2(16)CODE
PERSON_CODE_SUPERVISED_BYVarchar2(16)CODE
RANGE_CODEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
STEP_CODEVarchar2(16)CODE
FTENumber(9)AMT5V4
WORK_TYPEVarchar2(30)VARCHAR30
WCB_CLASSVarchar2(30)VARCHAR30
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
HOURS_PER_PAYNumber(9)AMT5V4
PERIODS_ELECTEDNumber(5)NUMBER5
CONTRACT_DAYSNumber(9)AMT5V4
CONTRACT_LIMITNumber(18)AMT12V6
USE_FTE_WAGESVarchar2(4)VARCHAR4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
OUT_OF_RANGEVarchar2(4)VARCHAR4
SCALE_OVERRIDDENVarchar2(4)VARCHAR4
ASSIGNMENT_TITLEVarchar2(50)DESCRIPTION
JOB_SENIORITY_DATEDate()DATE
RESPONSIBILITY_LEVELVarchar2(30)VARCHAR30
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
EMAIL_ADDRESSVarchar2(50)EMAIL
SERVICE_RATINGVarchar2(30)VARCHAR30
LEAVE_DATEDate()DATE
LEAVE_RETURN_DATEDate()DATE
LEAVE_REASONVarchar2(30)VARCHAR30
PAY_STARTING_DATEDate()DATE
TRIGGER_RETROVarchar2(4)VARCHAR4
PROVIDE_PUBLIC_SERVICEVarchar2(4)VARCHAR4
PROVIDE_INTERNAL_SERVICEVarchar2(4)VARCHAR4
SUPERVISORYVarchar2(4)VARCHAR4
BURDEN_METHODVarchar2(30)VARCHAR30
BURDEN_PERCENTNumber(18)AMT12V6
LONG_TERM_ASSIGNMENTVarchar2(4)VARCHAR4
REQUIRES_TIME_SHEETVarchar2(4)VARCHAR4
JOB_PROFILE_CODEVarchar2(16)CODE
WORK_CALENDAR_CODEVarchar2(16)CODE
WEB_PAY_STUB_ONLYVarchar2(4)VARCHAR4
PREMIUM_CODEVarchar2(16)CODE
PREMIUM_RATE_BASISVarchar2(30)VARCHAR30
PREMIUM_RATENumber(18)AMT12V6
SPLIT_SEQUENCENumber(5)NUMBER5
DISTRIBUTION_CODEVarchar2(50)DISTRIBUTION
SPLIT_RULEVarchar2(30)VARCHAR30
SPLIT_PERCENTNumber(5)PERCENT
SPLIT_AMOUNTNumber(18)AMT12V6
ADDITIONALVarchar2(4)VARCHAR4
START_DATEDate()DATE
END_DATEDate()DATE
GL_FUND_CODEVarchar2(16)CODE
USER_PERCENTNumber(5)PERCENT
USER_FIELD_VALUE_01Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_02Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_03Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_04Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_05Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_06Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_07Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_08Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_09Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_10Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_11Varchar2(2000)VARCHAR2000
USER_FIELD_VALUE_12Varchar2(2000)VARCHAR2000
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