TL_ABS_TEMP1(SQL Table) |
Index Back |
|---|---|
Absence Temp table 1Staging table contains absence data for pivot grid purposes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 4 | BGN_DT |
Date(10) | DATE | Begin Date |
| 5 | END_DT |
Date(10) | DATE | end date |
| 6 | BEGIN_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Partial Hours |
| 7 | BEGIN_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day
Y/N Table Edit Default Value: N |
| 8 | END_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | partial hours end |
| 9 | END_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit Default Value: N |
| 10 | ALL_DAYS_IND | Character(1) | VARCHAR2(1) NOT NULL |
All Days Indicator
N=Apply To Begin Day Only Y=Apply To All Days Default Value: N |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 12 | 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 |
| 13 | MANAGER_APPR_IND | Character(1) | VARCHAR2(1) NOT NULL | Manager Approved |