| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 5 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 6 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 7 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 8 |
ABSENCE_DATE |
Date(10) |
DATE |
Absence Date
|
| 9 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
|
| 10 |
ABS_DATA_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Absence Data Source: Event or Take Processing
1=Event Processing
2=Take Processing
Default Value: 1
|
| 11 |
DAY_OF_WK |
Character(1) |
VARCHAR2(1) NOT NULL |
Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 12 |
HOLIDAY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Holiday Type
BRG=Bridge Day
CAN=Canadian Statutory Holiday
HALF=1/2 Day Holiday
HIGH=High Holiday
HKGS=Hong Kong Statutory Holiday
LOW=Low Holiday
STD=Standard
USA=U.S. Statutory Holiday
VERY=Very High
Default Value: STD
|
| 13 |
HOLIDAY_HRS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Holiday Hours
|
| 14 |
EVT_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 15 |
EVT_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 16 |
EVT_CONFIG3 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 17 |
EVT_CONFIG4 |
Character(10) |
VARCHAR2(10) NOT NULL |
config char
|
| 18 |
EVT_CONFIG1_DT |
Date(10) |
DATE |
config date
|
| 19 |
EVT_CONFIG2_DT |
Date(10) |
DATE |
config date
|
| 20 |
EVT_CONFIG3_DT |
Date(10) |
DATE |
config date
|
| 21 |
EVT_CONFIG4_DT |
Date(10) |
DATE |
config date
|
| 22 |
EVT_CONFIG1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 23 |
EVT_CONFIG2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 24 |
EVT_CONFIG3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 25 |
EVT_CONFIG4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config dec
|
| 26 |
EVT_CONFIG1_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 27 |
EVT_CONFIG2_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 28 |
EVT_CONFIG3_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Config Monetary 3
|
| 29 |
EVT_CONFIG4_MON |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
config monetary
|
| 30 |
TAKE_CONFIG1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
| 31 |
TAKE_CONFIG2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
| 32 |
TAKE_CONFIG3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
| 33 |
TAKE_CONFIG4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Field reserved for custom attribution to an Absence Take
|
| 34 |
SCHED_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Scheduled Work Hours
|
| 35 |
WORKDAYID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Day ID
|
| 36 |
PTO_TIME1 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 1
|
| 37 |
PTO_TIME2 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 2
|
| 38 |
PTO_TIME3 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 3
|
| 39 |
PTO_TIME4 |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 4
|
| 40 |
SCHED_HRS_ALT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Alternate Scheduled Hours
|
| 41 |
WORKDAYID_ALT |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Day ID Alt
|
| 42 |
PTO_TIME1_ALT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 1
|
| 43 |
PTO_TIME2_ALT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 2
|
| 44 |
PTO_TIME3_ALT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 3
|
| 45 |
PTO_TIME4_ALT |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 4
|
| 46 |
SCHED_IND_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Indicator Override
Y/N Table Edit
|
| 47 |
SCHED_HRS_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Scheduled Hours Override
|
| 48 |
WORKDAYID_OVRD |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Day ID Override
|
| 49 |
PTO_TIME1_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 1 Override
|
| 50 |
PTO_TIME2_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 2 Override
|
| 51 |
PTO_TIME3_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 3 Override
|
| 52 |
PTO_TIME4_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 4 Override
|
| 53 |
SCHED_IND_ALT_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Schedule Overridden
Y/N Table Edit
|
| 54 |
SCHED_HRS_ALT_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Scheduled Hours Override
|
| 55 |
WORKDAYID_ALT_OVRD |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Day ID Override
|
| 56 |
PTO_TIME1_ALT_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 1 Override
|
| 57 |
PTO_TIME2_ALT_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 2 Override
|
| 58 |
PTO_TIME3_ALT_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 3 Override
|
| 59 |
PTO_TIME4_ALT_OVRD |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
User Defined 4 Override
|
| 60 |
ORIG_BEGIN_DT |
Date(10) |
DATE |
original begin date
|
| 61 |
PARTIAL_HRS |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Partial Hours
|
| 62 |
BEGIN_DAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin Absence Day
0=Begin Day No
1=Begin Day Yes
|
| 63 |
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
|
| 64 |
END_DAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
End Absence Day
0=End Day No
1=End Day Yes
|
| 65 |
END_DAY_HALF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit
|
| 66 |
DAY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing status on an absence date. Processed (P) or Unprocessed (U)
P=Processed
U=Unprocessed
Default Value: U
|
| 67 |
ABS_BGN_DT |
Date(10) |
DATE |
Absence Begin Date
|
| 68 |
ABS_END_DT |
Date(10) |
DATE |
Absence End Date
|
| 69 |
FIRST_EVT_BGN_DT |
Date(10) |
DATE |
First Event Begin Date
|
| 70 |
DAY_COUNT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Day Count
|
| 71 |
DAY_COUNT_PAID |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Day Count Paid
|
| 72 |
DAY_COUNT_UNPAID |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Day Count Unpaid
|
| 73 |
WAIT_COUNT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Wait Count
|
| 74 |
ELIG_DATE |
Date(10) |
DATE |
Eligibility Date Value
|
| 75 |
ELIG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligibility Indicator
Y/N Table Edit
|
| 76 |
MIN_PRD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Minimum Period
|
| 77 |
MIN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Period Indicator
Y/N Table Edit
|
| 78 |
LINK_PRD |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Link Period
|
| 79 |
LINKED_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked Indicator
Y/N Table Edit
|
| 80 |
CUM_EVENT_WAIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Cumulative Wait Count
|
| 81 |
CUM_LINKED_WAIT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Cum Linked Wait Units
|
| 82 |
BEGIN_WAIT_BAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Beginning Wait Balance
|
| 83 |
END_WAIT_BAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Ending Wait Balance
|
| 84 |
BEGIN_ENTL_BAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Begin Entitlement Balance
|
| 85 |
END_ENTL_BAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Entitlement Balance
|
| 86 |
PIN_MAP_TO_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 87 |
PIN_SOURCE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 88 |
PIN_NEG_ABS_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 89 |
ABS_TYPE_OPTN |
Character(3) |
VARCHAR2(3) NOT NULL |
Absence Type
Prompt Table:
GP_ABS_TYPE
|
| 90 |
ABSENCE_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
absence reason
10=Vacations
|
| 91 |
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.
|