GP_EA_STANRP_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
5	ACTION_DT	Date(10)	DATE	Action Date
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	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
11	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: %GP_EDIT_FLD1
12	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
13	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
14	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
15	HR_WF_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Workflow Action APV=Approved CAN=Cancelled by Originator DNY=Denied PND=Pending PSH=Push back for rework RAS=Reassign SAV=Saved For Later-Not Submitted SUB=Submitted
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
18	COMMENTS	Long Character	CLOB	Comment