Wiki: P 2 K_HR_ASSIGNMENT

Alias: EASD#

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 name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DDP_ID	Number(10)	ID	Y	link to P2K_CM_DEPARTMENTS
DES_ID	Number(10)	ID	Y	link to P2K_CM_EMPLOYMENT_STATUSES
DGR_ID	Number(10)	ID	Y	link to P2K_CM_GROUPS
DJB_ID	Number(10)	ID	Y	link to P2K_CM_JOBS
DLN_ID_WORK_IN	Number(10)	ID	Y	link to P2K_CM_LOCATIONS
DUN_ID	Number(10)	ID	Y	link to P2K_CM_UNITS
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
DAA_ID	Number(10)	ID		link to P2K_CM_AUTHORIZATION_AREAS
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
DLN_ID_PAYDEST	Number(10)	ID		link to P2K_CM_LOCATIONS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
DTX_ID	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
DWC_ID	Number(10)	ID		link to P2K_CM_WORK_CALENDARS
DWR_ID	Number(10)	ID		link to P2K_CM_WORK_RULES
EID_ID_SUPERVISED_BY	Number(10)	ID		link to P2K_HR_IDENTITIES
EID_ID_REPLACED_BY	Number(10)	ID		link to P2K_HR_IDENTITIES
RJP_ID	Number(10)	ID		link to P2K_RE_JOB_PROFILES
SSR_ID	Number(10)	ID		link to P2K_SA_SALARY_RANGES
SWSS_ID	Number(10)	ID		link to P2K_SA_WAGE_SCALE_STEPS
EFFECTIVE	Date()	EFFECTIVE	Y
EXPIRY	Date()	EXPIRY	Y
FTE	Number(9)	AMT5V4	Y
ASSIGNMENT_TITLE	Varchar2(50)	DESCRIPTION
HOURS_PER_DAY	Number(9)	AMT5V4
HOURS_PER_WEEK	Number(9)	AMT5V4
HOURS_PER_PAY	Number(9)	AMT5V4
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
USE_FTE_WAGES	Varchar2(1)	TOGGLE
OUT_OF_RANGE	Varchar2(1)	TOGGLE
SCALE_OVERRIDDEN	Varchar2(1)	TOGGLE
PERIODS_ELECTED	Number(5)	NUMBER5
PAY_STARTING_DATE	Date()	DATE
CONTRACT_DAYS	Number(9)	AMT5V4
CONTRACT_LIMIT	Number(18)	AMT12V6
JOB_SENIORITY_DATE	Date()	DATE
SERVICE_RATING	Varchar2(2)	X_SERVICE_RATING
RESPONSIBILITY_LEVEL	Varchar2(2)	X_RESPONSIBILITY_LEVEL
WORK_TYPE	Varchar2(2)	X_WORK_TYPE
WCB_CLASS	Varchar2(2)	X_WCB_CLASS
PHONE_NUMBER	Varchar2(20)	TELEPHONE
PHONE_EXTENSION	Varchar2(16)	VARCHAR16
EMAIL_ADDRESS	Varchar2(50)	EMAIL
LEAVE_DATE	Date()	DATE
LEAVE_REASON	Varchar2(2)	X_LEAVE_REASON
LEAVE_RETURN_DATE	Date()	DATE
TRIGGER_RETRO	Varchar2(1)	TOGGLE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
PROVIDE_PUBLIC_SERVICE	Varchar2(1)	TOGGLE
PROVIDE_INTERNAL_SERVICE	Varchar2(1)	TOGGLE
SUPERVISORY	Varchar2(1)	TOGGLE
BURDEN_METHOD	Varchar2(2)	X_BURDEN_METHOD
BURDEN_PERCENT	Number(18)	AMT12V6
LONG_TERM_ASSIGNMENT	Varchar2(1)	TOGGLE
REQUIRES_TIME_SHEET	Varchar2(1)	TOGGLE
WEB_PAY_STUB_ONLY	Varchar2(1)	TOGGLE
USE_WC_FOR_FLSA	Varchar2(1)	TOGGLE

User Fields: Allowed
Audit Logging: Allowed