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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top