This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 . It is not the current version, and thus it cannot be edited.

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 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
FLSA_HOURS	Number(9)	AMT5V4
DCL_ID_FLSA	Number(10)	ID		link to P2K_CM_CALENDARS
EXTERNAL_APPOINTMENT_ID	Varchar2(16)	VARCHAR16
EXTERNAL_MEMO	Varchar2(50)	VARCHAR50
BYPASS_ORG_CHART	Varchar2(1)	TOGGLE
ORG_RECORD_TYPE	Varchar2(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