!!!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|AMTnn]|Y|
|[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| |
|[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[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|NUMBERn]| |
|[PAY_STARTING_DATE]|Date()|[DATE]| |
|[CONTRACT_DAYS]|Number(9)|[AMT5V4|AMTnn]| |
|[CONTRACT_LIMIT]|Number(18)|[AMT12V6|AMTnn]| |
|[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|VARCHARnn]| |
|[EMAIL_ADDRESS(Field)]|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|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|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|AMTnn]| |
|[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|AMTnn]| |
|[DCL_ID_FLSA]|Number(10)|[ID]| |link to [P2K_CM_CALENDARS]
|[EXTERNAL_APPOINTMENT_ID]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[EXTERNAL_MEMO]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[BYPASS_ORG_CHART]|Varchar2(1)|[TOGGLE]| |
|[ORG_RECORD_TYPE]|Varchar2(2)|[X_ORG_RECORD_TYPE]| |
|[SP_COMPETENCY_RATING]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_SUCCESSOR_RANK]|Number(10)|[NUMBER5|NUMBERn]| |
|[SP_DESIGNATED_SUCCESSOR]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_HIGH_POTENTIAL_RATING]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_READINESS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_RETENTION_RISK]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_IMPACT_OF_LOSS]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_COMMENTS1]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SP_COMMENTS2]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[SSA_ID]|NUMBER(10,0)| [ID]| |
|[TRIGGER_BE_RETRO]|VARCHAR2(1)|[TOGGLE]| |
|[REPORT_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |


!![Derived Fields|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|Edit:Internal.P2K_HR_ASSIGNMENT_DETAILS] 	
[{InsertPage page='Internal.P2K_HR_ASSIGNMENT_DETAILS' default='Click to create a new notes page'}]