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

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

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