GP_ABS_EVENT_VW (SQL View)	Index Back
Absence Event View Absence Event View for Archiving puropse.

GP_ABS_EVENT_VW

(SQL View)

Absence Event View

Absence Event View for Archiving puropse.

SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM , END_DT , CAL_RUN_ID , ORIG_BEGIN_DT , ABS_ENTRY_SRC , PRC_EVT_ACTN_OPTN , VOIDED_IND , ABSENCE_REASON , BEGIN_DAY_HRS , BEGIN_DAY_HALF_IND , END_DAY_HRS , END_DAY_HALF_IND , ALL_DAYS_IND , 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 , CURRENCY_CD1 , CURRENCY_CD2 , CURRENCY_CD3 , CURRENCY_CD4 , MANAGER_APPR_IND , OVRD_ENT_VAL , OVRD_ADJ_VAL , PYE_RUN_NUM , LAST_UPDT_DT , PROCESS_DT , ABS_EVT_FCST_VAL , FCST_DTTM , DURATION_ABS , ACTION_DT_SS , WF_STATUS , TRANSACTION_NBR , COMMENTS FROM PS_GP_ABS_EVENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 BGN_DT Date(10) DATE NOT NULL Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

5 END_DT Date(10) DATE end date

6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

7 ORIG_BEGIN_DT Date(10) DATE original begin date

8 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator
2=Time & Labor
3=Third Party
4=Employee Self Service
5=Manager Self Service
6=Employee Timesheet
7=Manager Timesheet
Default Value: 1

9 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
N=Normal
V=Void
Default Value: N

10 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
Y/N Table Edit
Default Value: N

11 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
10=Vacations
Prompt Table: %GP_EDIT_FLD1

12 BEGIN_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Partial Hours

13 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

14 END_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL partial hours end

15 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator
Y/N Table Edit
Default Value: N

16 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

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

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

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

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

21 EVT_CONFIG1_DT Date(10) DATE config date

22 EVT_CONFIG2_DT Date(10) DATE config date

23 EVT_CONFIG3_DT Date(10) DATE config date

24 EVT_CONFIG4_DT Date(10) DATE config date

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

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

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

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

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

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

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

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

33 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

34 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

35 CURRENCY_CD3 Character(3) VARCHAR2(3) NOT NULL currency code
Prompt Table: CURRENCY_CD_TBL

36 CURRENCY_CD4 Character(3) VARCHAR2(3) NOT NULL currency code
Prompt Table: CURRENCY_CD_TBL

37 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
Y/N Table Edit
Default Value: N

38 OVRD_ENT_VAL Signed Number(12,6) DECIMAL(10,6) NOT NULL Override Entitlement Amoung

39 OVRD_ADJ_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Override Adjustment Amoung

40 PYE_RUN_NUM Number(8,0) INTEGER NOT NULL Number to link to Payee Run Table

41 LAST_UPDT_DT Date(10) DATE Date of last Update

42 PROCESS_DT Date(10) DATE Process Date

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

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

45 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

46 ACTION_DT_SS Date(10) DATE Date Submitted

47 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

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

49 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE	end date
6	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
7	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
8	ABS_ENTRY_SRC	Character(1)	VARCHAR2(1) NOT NULL	Absence Entry Source 1=Administrator 2=Time & Labor 3=Third Party 4=Employee Self Service 5=Manager Self Service 6=Employee Timesheet 7=Manager Timesheet Default Value: 1
9	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
10	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator Y/N Table Edit Default Value: N
11	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason 10=Vacations Prompt Table: %GP_EDIT_FLD1
12	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
13	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
14	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
15	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
16	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
17	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
18	EVT_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	config char
19	EVT_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	config char
20	EVT_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	config char
21	EVT_CONFIG1_DT	Date(10)	DATE	config date
22	EVT_CONFIG2_DT	Date(10)	DATE	config date
23	EVT_CONFIG3_DT	Date(10)	DATE	config date
24	EVT_CONFIG4_DT	Date(10)	DATE	config date
25	EVT_CONFIG1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
26	EVT_CONFIG2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
27	EVT_CONFIG3_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
28	EVT_CONFIG4_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config dec
29	EVT_CONFIG1_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
30	EVT_CONFIG2_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
31	EVT_CONFIG3_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Config Monetary 3
32	EVT_CONFIG4_MON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	config monetary
33	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
34	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
35	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
36	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
37	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
38	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
39	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
40	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table
41	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
42	PROCESS_DT	Date(10)	DATE	Process Date
43	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.
44	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.
45	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
46	ACTION_DT_SS	Date(10)	DATE	Date Submitted
47	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
48	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.
49	COMMENTS	Long Character	CLOB	Comment