GP_ABS_EANRP_VW (SQL View)	Index Back
AM EA Main Record NRP Extended Absence Main Record - Packaging View

GP_ABS_EANRP_VW

(SQL View)

AM EA Main Record NRP

Extended Absence Main Record - Packaging View

SELECT EMPLID , EMPL_RCD ,TRANSACTION_NBR ,PIN_TAKE_NUM + 50000000 ,BGN_DT ,END_DT ,RETURN_DT ,REQUEST_DT ,ABS_ENTRY_SRC ,ABSENCE_REASON ,MANAGER_APPR_IND ,LAST_UPDT_DT ,WF_STATUS ,COMMENTS FROM PS_GP_ABS_EA

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

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

5 BGN_DT Date(10) DATE NOT NULL Begin Date
Default Value: %date

6 END_DT Date(10) DATE NOT NULL end date

7 RETURN_DT Date(10) DATE Return Date

8 REQUEST_DT Date(10) DATE NOT NULL Request Date
Default Value: %date

9 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

10 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
Prompt Table: GP_ABS_REASN_VW

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

12 LAST_UPDT_DT Date(10) DATE Date of last Update

13 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

14 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	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.
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	BGN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %date
6	END_DT	Date(10)	DATE NOT NULL	end date
7	RETURN_DT	Date(10)	DATE	Return Date
8	REQUEST_DT	Date(10)	DATE NOT NULL	Request Date Default Value: %date
9	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
10	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: GP_ABS_REASN_VW
11	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
12	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
13	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
14	COMMENTS	Long Character	CLOB	Comment