GP_ABSEA_NRP_AD(SQL Table) |
Index Back |
---|---|
AM EA Main RecordExtended 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 |