GP_RSLT_ABS_HST (SQL Table)	Index Back
Absence Data Table - Daily Absence Data Table - Daily

GP_RSLT_ABS_HST

(SQL Table)

Absence Data Table - Daily

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

10 ABSENCE_DATE Date(10) DATE Absence Date

11 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

12 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

13 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

14 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

15 HOLIDAY_HRS Number(5,2) DECIMAL(4,2) NOT NULL Holiday Hours

16 EVT_CONFIG1 Character(10) VARCHAR2(10) NOT NULL config char

17 EVT_CONFIG2 Character(10) VARCHAR2(10) NOT NULL config char

18 EVT_CONFIG3 Character(10) VARCHAR2(10) NOT NULL config char

19 EVT_CONFIG4 Character(10) VARCHAR2(10) NOT NULL config char

20 EVT_CONFIG1_DT Date(10) DATE config date

21 EVT_CONFIG2_DT Date(10) DATE config date

22 EVT_CONFIG3_DT Date(10) DATE config date

23 EVT_CONFIG4_DT Date(10) DATE config date

24 EVT_CONFIG1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec

25 EVT_CONFIG2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec

26 EVT_CONFIG3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec

27 EVT_CONFIG4_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec

28 EVT_CONFIG1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary

29 EVT_CONFIG2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary

30 EVT_CONFIG3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Config Monetary 3

31 EVT_CONFIG4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary

32 TAKE_CONFIG1 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take

33 TAKE_CONFIG2 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take

34 TAKE_CONFIG3 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take

35 TAKE_CONFIG4 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take

36 SCHED_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Work Hours

37 WORKDAYID Character(10) VARCHAR2(10) NOT NULL Work Day ID

38 PTO_TIME1 Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 1

39 PTO_TIME2 Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 2

40 PTO_TIME3 Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 3

41 PTO_TIME4 Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 4

42 SCHED_HRS_ALT Signed Number(6,2) DECIMAL(4,2) NOT NULL Alternate Scheduled Hours

43 WORKDAYID_ALT Character(10) VARCHAR2(10) NOT NULL Work Day ID Alt

44 PTO_TIME1_ALT Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 1

45 PTO_TIME2_ALT Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 2

46 PTO_TIME3_ALT Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 3

47 PTO_TIME4_ALT Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 4

48 SCHED_IND_OVRD Character(1) VARCHAR2(1) NOT NULL Schedule Indicator Override
Y/N Table Edit

49 SCHED_HRS_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Hours Override

50 WORKDAYID_OVRD Character(10) VARCHAR2(10) NOT NULL Work Day ID Override

51 PTO_TIME1_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 1 Override

52 PTO_TIME2_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 2 Override

53 PTO_TIME3_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 3 Override

54 PTO_TIME4_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 4 Override

55 SCHED_IND_ALT_OVRD Character(1) VARCHAR2(1) NOT NULL Alternate Schedule Overridden
Y/N Table Edit

56 SCHED_HRS_ALT_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Hours Override

57 WORKDAYID_ALT_OVRD Character(10) VARCHAR2(10) NOT NULL Work Day ID Override

58 PTO_TIME1_ALT_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 1 Override

59 PTO_TIME2_ALT_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 2 Override

60 PTO_TIME3_ALT_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 3 Override

61 PTO_TIME4_ALT_OVRD Signed Number(6,2) DECIMAL(4,2) NOT NULL User Defined 4 Override

62 ORIG_BEGIN_DT Date(10) DATE original begin date

63 PARTIAL_HRS Signed Number(10,5) DECIMAL(8,5) NOT NULL Partial Hours

64 BEGIN_DAY_IND Character(1) VARCHAR2(1) NOT NULL Begin Absence Day
0=Begin Day No
1=Begin Day Yes

65 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

66 END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day
0=End Day No
1=End Day Yes

67 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator
Y/N Table Edit

68 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

69 ABS_BGN_DT Date(10) DATE Absence Begin Date

70 ABS_END_DT Date(10) DATE Absence End Date

71 FIRST_EVT_BGN_DT Date(10) DATE First Event Begin Date

72 DAY_COUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count

73 DAY_COUNT_PAID Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count Paid

74 DAY_COUNT_UNPAID Signed Number(20,6) DECIMAL(18,6) NOT NULL Day Count Unpaid

75 WAIT_COUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Wait Count

76 ELIG_DATE Date(10) DATE Eligibility Date Value

77 ELIG_IND Character(1) VARCHAR2(1) NOT NULL Eligibility Indicator
Y/N Table Edit

78 MIN_PRD Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Period

79 MIN_IND Character(1) VARCHAR2(1) NOT NULL Minimum Period Indicator
Y/N Table Edit

80 LINK_PRD Signed Number(20,6) DECIMAL(18,6) NOT NULL Link Period

81 LINKED_IND Character(1) VARCHAR2(1) NOT NULL Linked Indicator
Y/N Table Edit

82 CUM_EVENT_WAIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Cumulative Wait Count

83 CUM_LINKED_WAIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Cum Linked Wait Units

84 BEGIN_WAIT_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Beginning Wait Balance

85 END_WAIT_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Ending Wait Balance

86 BEGIN_ENTL_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Begin Entitlement Balance

87 END_ENTL_BAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Entitlement Balance

88 PIN_MAP_TO_NUM Number(8,0) INTEGER NOT NULL Element number field

89 PIN_SOURCE_NUM Number(8,0) INTEGER NOT NULL Element number field

90 PIN_NEG_ABS_NUM Number(8,0) INTEGER NOT NULL Element number field

91 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
Prompt Table: GP_ABS_TYPE

92 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
10=Vacations

93 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.

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