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 ,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
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
2=Time & Labor
3=Third Party
4=Employee Self Service
5=Manager Self Service
6=Employee Timesheet
7=Manager Timesheet
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
10=Vacations

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 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 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 2=Time & Labor 3=Third Party 4=Employee Self Service 5=Manager Self Service 6=Employee Timesheet 7=Manager Timesheet 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 10=Vacations
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	COMMENTS	Long Character	CLOB	Comment