P 2 K_HR_ASSIGNMENT_DETAILS
Back to current versionRestore this version

Alias: EASD#

(P2K_HR_ASSIGNMENT_DETAILS)

Unique Keys: EAS_ID (Assignment) + EFFECTIVE + EXPIRY
Child Table: P2K_CM_DISTRIBUTIONS, P2K_SA_PREMIUM_USAGES
Parent Table: P2K_HR_ASSIGNMENTS

Provides all of the details for the employee's assignment

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DDP_IDNumber(10)IDYlink to P2K_CM_DEPARTMENTS
DES_IDNumber(10)IDYlink to P2K_CM_EMPLOYMENT_STATUSES
DGR_IDNumber(10)IDYlink to P2K_CM_GROUPS
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
DLN_ID_WORK_INNumber(10)IDYlink to P2K_CM_LOCATIONS
DUN_IDNumber(10)IDYlink to P2K_CM_UNITS
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
DAA_IDNumber(10)ID link to P2K_CM_AUTHORIZATION_AREAS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
DLN_ID_PAYDESTNumber(10)ID link to P2K_CM_LOCATIONS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
DWC_IDNumber(10)ID link to P2K_CM_WORK_CALENDARS
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
EID_ID_SUPERVISED_BYNumber(10)ID link to P2K_HR_IDENTITIES
EID_ID_REPLACED_BYNumber(10)ID link to P2K_HR_IDENTITIES
RJP_IDNumber(10)ID link to P2K_RE_JOB_PROFILES
SSR_IDNumber(10)ID link to P2K_SA_SALARY_RANGES
SWSS_IDNumber(10)ID link to P2K_SA_WAGE_SCALE_STEPS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
FTENumber(9)AMT5V4Y
ASSIGNMENT_TITLEVarchar2(50)DESCRIPTION
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
HOURS_PER_PAYNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
USE_FTE_WAGESVarchar2(1)TOGGLE
OUT_OF_RANGEVarchar2(1)TOGGLE
SCALE_OVERRIDDENVarchar2(1)TOGGLE
PERIODS_ELECTEDNumber(5)NUMBER5
PAY_STARTING_DATEDate()DATE
CONTRACT_DAYSNumber(9)AMT5V4
CONTRACT_LIMITNumber(18)AMT12V6
JOB_SENIORITY_DATEDate()DATE
SERVICE_RATINGVarchar2(2)X_SERVICE_RATING
RESPONSIBILITY_LEVELVarchar2(2)X_RESPONSIBILITY_LEVEL
WORK_TYPEVarchar2(2)X_WORK_TYPE
WCB_CLASSVarchar2(2)X_WCB_CLASS
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
EMAIL_ADDRESSVarchar2(50)EMAIL
LEAVE_DATEDate()DATE
LEAVE_REASONVarchar2(2)X_LEAVE_REASON
LEAVE_RETURN_DATEDate()DATE
TRIGGER_RETROVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PROVIDE_PUBLIC_SERVICEVarchar2(1)TOGGLE
PROVIDE_INTERNAL_SERVICEVarchar2(1)TOGGLE
SUPERVISORYVarchar2(1)TOGGLE
BURDEN_METHODVarchar2(2)X_BURDEN_METHOD
BURDEN_PERCENTNumber(18)AMT12V6
LONG_TERM_ASSIGNMENTVarchar2(1)TOGGLE
REQUIRES_TIME_SHEETVarchar2(1)TOGGLE
WEB_PAY_STUB_ONLYVarchar2(1)TOGGLE
USE_WC_FOR_FLSAVarchar2(1)TOGGLE
FLSA_HOURSNumber(9)AMT5V4
DCL_ID_FLSANumber(10)ID link to P2K_CM_CALENDARS
EXTERNAL_APPOINTMENT_IDVarchar2(16)VARCHAR16
EXTERNAL_MEMOVarchar2(50)VARCHAR50
BYPASS_ORG_CHARTVarchar2(1)TOGGLE
ORG_RECORD_TYPEVarchar2(2)X_ORG_RECORD_TYPE

Derived Fields#

Column Name
DRV_ANNUAL
DRV_AS_OF_DATE
DRV_BI_WEEKLY
DRV_COMPA_RATIO
DRV_CONTRACT_CALENDAR
DRV_DAILY
DRV_DESCRIPTION1
DRV_DESCRIPTION2
DRV_DISTRIBUTION_MESSAGE
DRV_HOURLY
DRV_LAST_CHANGED_DATE
DRV_LAST_CHANGED_WAGE
DRV_MAX_SALARY
DRV_MID_SALARY
DRV_MIN_SALARY
DRV_MONTHLY
DRV_QUARTILE
DRV_SCALE_RATE
DRV_SCHOOL_DAYS
DRV_SEMI_MONTHLY
DRV_SHOW_INDIRECT_EES
DRV_WAGE
DRV_WAGE_ADJUSTMENT_TYPE
DRV_WAGE_ADJUSTMENT_VALUE
DRV_WEEKLY
EID_ID_FIRST_MANAGER

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page