GP_NRP_ABSEV_VW (SQL View)	Index Back
Absence Event Definition View Absence Event Definition - Packaging View

GP_NRP_ABSEV_VW

(SQL View)

Absence Event Definition View

Absence Event Definition - Packaging View

SELECT EMPLID ,EMPL_RCD ,BGN_DT ,PIN_TAKE_NUM + 50000000 ,END_DT ,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 ,CAL_RUN_ID ,PYE_RUN_NUM ,LAST_UPDT_DT ,PROCESS_DT ,ABS_EVT_FCST_VAL ,FCST_DTTM ,DURATION_ABS ,ACTION_DT_SS ,WF_STATUS ,TRANSACTION_NBR ,TRANSACTION_NBR_EA ,DURATION_DYS ,DURATION_HOURS ,START_TIME ,END_TIME ,START_TIME2 ,END_TIME2 ,FIRST_PROC_DT ,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 Record

3 BGN_DT Date(10) DATE NOT NULL Begin Date
Default Value: %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 NOT NULL end date
Default Value: GP_ABS_EVENT.BGN_DT

6 ORIG_BEGIN_DT Date(10) DATE NOT NULL original begin date
Default Value: GP_ABS_EVENT.BGN_DT

7 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

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

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

10 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason

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

12 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

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

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

15 ALL_DAYS_IND Character(1) VARCHAR2(1) NOT NULL All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days
Y/N Table Edit
Default Value: N

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 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

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

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

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

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

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

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

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 Termination Date

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 TRANSACTION_NBR_EA Number(15,0) DECIMAL(15) NOT NULL The Extendned Absence transaction number

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

51 DURATION_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Duration (Hours)

52 START_TIME Time(15) TIMESTAMP Interview Start Time

53 END_TIME Time(15) TIMESTAMP Interview End Time

54 START_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing Start Time of Absence Take

55 END_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing End Time of Absence Take

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

57 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 Record
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %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 NOT NULL	end date Default Value: GP_ABS_EVENT.BGN_DT
6	ORIG_BEGIN_DT	Date(10)	DATE NOT NULL	original begin date Default Value: GP_ABS_EVENT.BGN_DT
7	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
8	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
9	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator Y/N Table Edit Default Value: N
10	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
11	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
12	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
13	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
14	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
15	ALL_DAYS_IND	Character(1)	VARCHAR2(1) NOT NULL	All Days Indicator N=Apply To Begin Day Only Y=Apply To All Days Y/N Table Edit Default Value: N
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	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
33	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
34	CURRENCY_CD3	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
35	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code Prompt Table: CURRENCY_CD_TBL
36	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
37	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
38	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
39	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
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	Termination Date
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	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number
50	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
51	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
52	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
53	END_TIME	Time(15)	TIMESTAMP	Interview End Time
54	START_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing Start Time of Absence Take
55	END_TIME2	Time(15)	TIMESTAMP	Contains End Time. Primarly created for storing End Time of Absence Take
56	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.
57	COMMENTS	Long Character	CLOB	Comment