| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 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 NOT NULL |
Begin Date
|
| 5 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
Prompt Table:
GP_PIN_ABSTK_VW
|
| 6 |
END_DT |
Date(10) |
DATE |
end date
|
| 7 |
GPFR_DA_STRUCT |
Character(50) |
VARCHAR2(50) NOT NULL |
DADS related field
|
| 8 |
GPFR_DA_RECORD |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related record
|
| 9 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 10 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 11 |
GPFR_DSN_ABS_RSN |
Character(20) |
VARCHAR2(20) NOT NULL |
Captures absence reason code for DSN Norm.
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 13 |
GPFR_AF_APPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Application Framework - Application
|
| 14 |
GPFR_AF_EXTRACT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Application Framework - Extraction ID
|
| 15 |
GPFR_AF_NODE_SET |
Character(16) |
VARCHAR2(16) NOT NULL |
Application Framework - Node Set
|
| 16 |
GPFR_AF_SNDREF |
Character(10) |
VARCHAR2(10) NOT NULL |
Application Framework - Sending Reference
|
| 17 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 18 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 19 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 20 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
|
| 21 |
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
|
| 22 |
PRC_EVT_ACTN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal
V=Void
Default Value: N
|
| 23 |
VOIDED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Voided Indicator
Y/N Table Edit
Default Value: N
|
| 24 |
ABSENCE_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
absence reason
Prompt Table:
%GP_EDIT_FLD1
|
| 25 |
BEGIN_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Partial Hours
|
| 26 |
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
|
| 27 |
END_DAY_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
partial hours end
|
| 28 |
END_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit
Default Value: N
|
| 29 |
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
|
| 30 |
START_TIME |
Time(15) |
TIMESTAMP |
Interview Start Time
|
| 31 |
END_TIME |
Time(15) |
TIMESTAMP |
Interview End Time
|
| 32 |
START_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing Start Time of Absence Take
|
| 33 |
END_TIME2 |
Time(15) |
TIMESTAMP |
Contains End Time. Primarly created for storing End Time of Absence Take
|
| 34 |
EVT_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 35 |
EVT_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 36 |
EVT_CONFIG3 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 37 |
EVT_CONFIG4 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 38 |
EVT_CONFIG1_DT |
Date(10) |
DATE |
config date
|
| 39 |
EVT_CONFIG2_DT |
Date(10) |
DATE |
config date
|
| 40 |
EVT_CONFIG3_DT |
Date(10) |
DATE |
config date
|
| 41 |
EVT_CONFIG4_DT |
Date(10) |
DATE |
config date
|
| 42 |
EVT_CONFIG1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 43 |
EVT_CONFIG2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 44 |
EVT_CONFIG3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 45 |
EVT_CONFIG4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 46 |
EVT_CONFIG1_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 47 |
EVT_CONFIG2_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 48 |
EVT_CONFIG3_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Config Monetary 3
|
| 49 |
EVT_CONFIG4_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 50 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 51 |
CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 52 |
CURRENCY_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
Prompt Table:
CURRENCY_CD_TBL
|
| 53 |
CURRENCY_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
currency code
Prompt Table:
CURRENCY_CD_TBL
|
| 54 |
MANAGER_APPR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Approved
Y/N Table Edit
Default Value: N
|
| 55 |
OVRD_ENT_VAL |
Signed Number(12,6) |
DECIMAL(10,6) NOT NULL |
Override Entitlement Amoung
|
| 56 |
OVRD_ADJ_VAL |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Override Adjustment Amoung
|
| 57 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 58 |
PYE_RUN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Number to link to Payee Run Table
|
| 59 |
LAST_UPDT_DT |
Date(10) |
DATE |
Date of last Update
|
| 60 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 61 |
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.
|
| 62 |
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.
|
| 63 |
DURATION_ABS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Duration field containing 2 decimals to handle absence requirements
|
| 64 |
ACTION_DT_SS |
Date(10) |
DATE |
Date Submitted
|
| 65 |
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
|
| 66 |
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.
|
| 67 |
TRANSACTION_NBR_EA |
Number(15,0) |
DECIMAL(15) NOT NULL |
The Extendned Absence transaction number
Default Value: 0
|
| 68 |
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.
|
| 69 |
GPFR_DSN_LASTW_DAY |
Date(10) |
DATE |
Last worked day before the absence
|
| 70 |
GPFR_DSN_NEXTW_DAY |
Date(10) |
DATE |
Next working day after the absence
|
| 71 |
GPFR_DSN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
DSN Type
|
| 72 |
GPFR_DSN_EXT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
DSN extraction source
M=Manual
P=Process
Default Value: P
|
| 73 |
GPFR_DSN_EVT_EEACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to decide the action for the employee: Report / Cancel and Replace / Cancel / Blank. Default is determined by application framework parameter CUSTOM / EVT_EE_SEL_ACTION. Blank means employee is not reported.
C=Cancel
R=Replace
S=Report
|
| 74 |
GPFR_DSN_DECL_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
DSN Declaration reference
|
| 75 |
GPFR_DSN_REPL_DECL |
Character(15) |
VARCHAR2(15) NOT NULL |
DSN Event declaration reference to be replaced or cancelled
|
| 76 |
GPFR_DSN_REP_SD_DT |
Date(10) |
DATE |
Replaced declaration send date
|
| 77 |
COMMENTS |
Long Character |
CLOB |
Comment
|