| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 5 |
BGN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
|
| 6 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
Prompt Table:
GP_PIN_ABSTK_VW
|
| 7 |
END_DT |
Date(10) |
DATE |
end date
|
| 8 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 9 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
Default Value: GP_ABS_EVENT.BGN_DT
|
| 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
Default Value: 1
|
| 11 |
PRC_EVT_ACTN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal
V=Void
Default Value: N
|
| 12 |
VOIDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Voided Indicator
Y/N Table Edit
Default Value: N
|
| 13 |
ABSENCE_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
absence reason
Prompt Table:
%GP_EDIT_FLD1
|
| 14 |
BEGIN_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 15 |
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
|
| 16 |
END_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
partial hours end
|
| 17 |
END_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit
Default Value: N
|
| 18 |
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
|
| 19 |
START_TIME |
Time(15) |
TIMESTAMP |
Interview Start Time
|
| 20 |
END_TIME |
Time(15) |
TIMESTAMP |
Interview End Time
|
| 21 |
START_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing Start Time of Absence Take
|
| 22 |
END_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing End Time of Absence Take
|
| 23 |
EVT_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 24 |
EVT_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 25 |
EVT_CONFIG3 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 26 |
EVT_CONFIG4 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 27 |
EVT_CONFIG1_DT |
Date(10) |
DATE |
config date
|
| 28 |
EVT_CONFIG2_DT |
Date(10) |
DATE |
config date
|
| 29 |
EVT_CONFIG3_DT |
Date(10) |
DATE |
config date
|
| 30 |
EVT_CONFIG4_DT |
Date(10) |
DATE |
config date
|
| 31 |
EVT_CONFIG1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 32 |
EVT_CONFIG2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 33 |
EVT_CONFIG3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 34 |
EVT_CONFIG4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 35 |
EVT_CONFIG1_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 36 |
EVT_CONFIG2_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 37 |
EVT_CONFIG3_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Config Monetary 3
|
| 38 |
EVT_CONFIG4_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 39 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 40 |
CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 41 |
CURRENCY_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
Prompt Table:
CURRENCY_CD_TBL
|
| 42 |
CURRENCY_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
Prompt Table:
CURRENCY_CD_TBL
|
| 43 |
MANAGER_APPR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Approved
Y/N Table Edit
Default Value: N
|
| 44 |
OVRD_ENT_VAL |
Signed Number(12,6) |
DECIMAL(10,6) NOT NULL |
Override Entitlement Amoung
|
| 45 |
OVRD_ADJ_VAL |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Override Adjustment Amoung
|
| 46 |
PYE_RUN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Number to link to Payee Run Table
|
| 47 |
LAST_UPDT_DT |
Date(10) |
DATE |
Date of last Update
|
| 48 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 49 |
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.
|
| 50 |
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.
|
| 51 |
DURATION_ABS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 52 |
DURATION_DYS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 53 |
DURATION_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration (Hours)
|
| 54 |
ACTION_DT_SS |
Date(10) |
DATE |
Date Submitted
|
| 55 |
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
|
| 56 |
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.
|
| 57 |
TRANSACTION_NBR_EA |
Number(15,0) |
DECIMAL(15) NOT NULL |
The Extendned Absence transaction number
Default Value: 0
|
| 58 |
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.
|
| 59 |
ABS_CAN_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Cancel Reason
|
| 60 |
COMMENTS |
Long Character |
CLOB |
Comment
|