| # |
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 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 5 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
|
| 6 |
END_DT |
Date(10) |
DATE |
end date
|
| 7 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
|
| 8 |
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
|
| 9 |
PRC_EVT_ACTN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal
V=Void
|
| 10 |
VOIDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Voided Indicator
|
| 11 |
ABSENCE_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
absence reason
|
| 12 |
BEGIN_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 13 |
BEGIN_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day
|
| 14 |
END_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
partial hours end
|
| 15 |
END_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
half day end indicator
|
| 16 |
ALL_DAYS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days
|
| 17 |
START_TIME |
Time(15) |
TIMESTAMP |
Interview Start Time
|
| 18 |
END_TIME |
Time(15) |
TIMESTAMP |
Interview End Time
|
| 19 |
START_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing Start Time of Absence Take
|
| 20 |
END_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing End Time of Absence Take
|
| 21 |
EVT_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 22 |
EVT_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 23 |
EVT_CONFIG3 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 24 |
EVT_CONFIG4 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 25 |
EVT_CONFIG1_DT |
Date(10) |
DATE |
config date
|
| 26 |
EVT_CONFIG2_DT |
Date(10) |
DATE |
config date
|
| 27 |
EVT_CONFIG3_DT |
Date(10) |
DATE |
config date
|
| 28 |
EVT_CONFIG4_DT |
Date(10) |
DATE |
config date
|
| 29 |
EVT_CONFIG1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 30 |
EVT_CONFIG2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 31 |
EVT_CONFIG3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 32 |
EVT_CONFIG4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 33 |
EVT_CONFIG1_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 34 |
EVT_CONFIG2_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 35 |
EVT_CONFIG3_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Config Monetary 3
|
| 36 |
EVT_CONFIG4_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 37 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 38 |
CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 39 |
CURRENCY_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
|
| 40 |
CURRENCY_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
|
| 41 |
MANAGER_APPR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Approved
|
| 42 |
OVRD_ENT_VAL |
Signed Number(12,6) |
DECIMAL(10,6) NOT NULL |
Override Entitlement Amoung
|
| 43 |
OVRD_ADJ_VAL |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Override Adjustment Amoung
|
| 44 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 45 |
PYE_RUN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Number to link to Payee Run Table
|
| 46 |
LAST_UPDT_DT |
Date(10) |
DATE |
Date of last Update
|
| 47 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 48 |
ABS_EVT_FCST_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
|
| 49 |
FCST_DTTM |
DateTime(26) |
TIMESTAMP |
This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.
|
| 50 |
DURATION_ABS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 51 |
DURATION_DYS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 52 |
DURATION_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration (Hours)
|
| 53 |
ACTION_DT_SS |
Date(10) |
DATE |
Date Submitted
|
| 54 |
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
|
| 55 |
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.
|
| 56 |
TRANSACTION_NBR_EA |
Number(15,0) |
DECIMAL(15) NOT NULL |
The Extendned Absence transaction number
|
| 57 |
FIRST_PROC_DT |
Date(10) |
DATE |
GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
|
| 58 |
COMMENTS |
Long Character |
CLOB |
Comment
|