GP_ABSEAHIST_VW

#	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_EDIT_FLD1
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
15	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country