GP_EAHST_NRP_VW (SQL View)	Index Back
AM EA Main Record Archive NRP Packaging Def for Extended Absence Main Record Archive

GP_EAHST_NRP_VW

(SQL View)

AM EA Main Record Archive NRP

Packaging Def for Extended Absence Main Record Archive

SELECT PSARCH_ID ,PSARCH_BATCHNUM ,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_HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

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

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

8 END_DT Date(10) DATE NOT NULL end date

9 RETURN_DT Date(10) DATE Return Date

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

11 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

12 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
Prompt Table: %GP_EDIT_FLD1

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

14 LAST_UPDT_DT Date(10) DATE Date of last Update

15 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

16 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	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.
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
7	BGN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %date
8	END_DT	Date(10)	DATE NOT NULL	end date
9	RETURN_DT	Date(10)	DATE	Return Date
10	REQUEST_DT	Date(10)	DATE NOT NULL	Request Date Default Value: %date
11	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
12	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: %GP_EDIT_FLD1
13	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
14	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
15	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
16	COMMENTS	Long Character	CLOB	Comment