GP_NRP_RSABS_VW (SQL View)	Index Back
Absence Data View Absence Data Daily Packaging View

GP_NRP_RSABS_VW

(SQL View)

Absence Data View

Absence Data Daily Packaging View

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,ABSENCE_DATE ,PIN_TAKE_NUM + 50000000 ,ABS_DATA_SRC ,DAY_OF_WK ,HOLIDAY_TYPE ,HOLIDAY_HRS ,EVT_CONFIG1 ,EVT_CONFIG2 ,EVT_CONFIG3 ,EVT_CONFIG4 ,EVT_CONFIG1_DT ,EVT_CONFIG2_DT ,EVT_CONFIG3_DT ,EVT_CONFIG4_DT ,EVT_CONFIG1_DEC ,EVT_CONFIG2_DEC ,EVT_CONFIG3_DEC ,EVT_CONFIG4_DEC ,EVT_CONFIG1_MON ,EVT_CONFIG2_MON ,EVT_CONFIG3_MON ,EVT_CONFIG4_MON ,TAKE_CONFIG1 ,TAKE_CONFIG2 ,TAKE_CONFIG3 ,TAKE_CONFIG4 ,SCHED_HRS ,WORKDAYID ,PTO_TIME1 ,PTO_TIME2 ,PTO_TIME3 ,PTO_TIME4 ,SCHED_HRS_ALT ,WORKDAYID_ALT ,PTO_TIME1_ALT ,PTO_TIME2_ALT ,PTO_TIME3_ALT ,PTO_TIME4_ALT ,SCHED_IND_OVRD ,SCHED_HRS_OVRD ,WORKDAYID_OVRD ,PTO_TIME1_OVRD ,PTO_TIME2_OVRD ,PTO_TIME3_OVRD ,PTO_TIME4_OVRD ,SCHED_IND_ALT_OVRD ,SCHED_HRS_ALT_OVRD ,WORKDAYID_ALT_OVRD ,PTO_TIME1_ALT_OVRD ,PTO_TIME2_ALT_OVRD ,PTO_TIME3_ALT_OVRD ,PTO_TIME4_ALT_OVRD ,ORIG_BEGIN_DT ,PARTIAL_HRS ,BEGIN_DAY_IND ,BEGIN_DAY_HALF_IND ,END_DAY_IND ,END_DAY_HALF_IND ,DAY_STATUS ,ABS_BGN_DT ,ABS_END_DT ,FIRST_EVT_BGN_DT ,DAY_COUNT ,DAY_COUNT_PAID ,DAY_COUNT_UNPAID ,WAIT_COUNT ,ELIG_DATE ,ELIG_IND ,MIN_PRD ,MIN_IND ,LINK_PRD ,LINKED_IND ,CUM_EVENT_WAIT ,CUM_LINKED_WAIT ,BEGIN_WAIT_BAL ,END_WAIT_BAL ,BEGIN_ENTL_BAL ,END_ENTL_BAL ,PIN_MAP_TO_NUM + 50000000 ,PIN_SOURCE_NUM + 50000000 ,PIN_NEG_ABS_NUM + 50000000 ,ABS_TYPE_OPTN ,ABSENCE_REASON ,ABS_EVT_FCST_VAL FROM PS_GP_RSLT_ABS

# 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

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.

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