GP_ABSEA_NRP_AD

(SQL Table)
Index Back

AM EA Main Record

Extended Absence Main Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
6 BGN_DT Date(10) DATE Begin Date
7 END_DT Date(10) DATE end date
8 RETURN_DT Date(10) DATE Return Date
9 REQUEST_DT Date(10) DATE Request Date
10 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration
11 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
12 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
13 LAST_UPDT_DT Date(10) DATE Date of last Update
14 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
15 COMMENTS Long Character CLOB Comment