!!!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]|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]| | !![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'}]