Alias: AAL#

(P2K_AT_LEAVE_LINES)

Unique Keys:
Child Table:
Parent Table:

Leave Lines

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
DTC_ID	Number(10)	ID		link to P2K_CM_TIME_CODES
PPL_ID	Number(10)	ID		link to P2K_PR_PAY_LINES
ALPT_ID	Number(10)	ID		link to P2K_AT_LEAVE_POLICY_TYPES
MEX_ID	Number(10)	ID		link to P2K_AM_EXECUTIONS
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
START_DATE	Date()	DATE	Y
END_DATE	Date()	DATE	Y
ORIG_LEAVE_BEGIN_DATE	Date()	DATE	Y
ACCRUAL_STATUS	Varchar2(2)	X_ACCRUAL_STATUS	Y
LINE_NUMBER	Number(5)	NUMBER5
DESCRIPTION	Varchar2(50)	DESCRIPTION
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
LEAVE_REASON	Varchar2(2)	X_LEAVE_REASON
LEAVE_CERTIFIED	Varchar2(2)	X_LEAVE_CERTIFIED
PAYROLL_COMPLETE	Varchar2(1)	TOGGLE
LEAVE_APPROVAL	Varchar2(2)	X_LEAVE_APPROVAL
LEAVE_TIME_NOT_TAKEN	Number(18)	AMT12V6
ABSENCE_SOURCE_MODULE	Varchar2(2)	X_ABSENCE_SOURCE
ABSENCE_SOURCE_KEY	Varchar2(50)	VARCHAR50
ENTITLEMENT_EARNED	Varchar2(1)	TOGGLE
OVERALL_LEAVE_TIME	Number(18)	AMT12V6
TIME_BASIS	Varchar2(2)	X_TIME_BASIS
BANK_TIME_STILL_OWING	Varchar2(1)	TOGGLE
ACTUAL_LEAVE	Varchar2(1)	TOGGLE
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
START_TIME	Number(5)	MINUTES
END_TIME	Number(5)	MINUTES
PARTIALLY_PROCESSED	Varchar2(1)	TOGGLE
PROJECTED_TIME	Number(18)	AMT12V6
PTSE_ID	Number(10)	ID		link to P2K_PR_TIME_SHEET_ENTRIES
PTRC_ID	Number(10)	ID		link to P2K_PR_PAY_TRANS_TIME_CODES
CASCADED	Varchar2(1)	TOGGLE
LEAVE_REASON_TEXT	Varchar2(4000)	VARCHAR4000

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_CALENDAR_NAVIGATION_RULES
DRV_END_TIME
DRV_LEAVE_TIME
DRV_START_TIME

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page