EX_ADV_HDR_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID Default Value: NEXT
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	ADV_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Advance Status APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNU=Denied by Auditor HDA=On Hold, with Approver HDU=On Hold, with Auditor HLD=On Hold PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process PST=Past Due Balance RAP=Approved RCN=Reconciled RRT=Reroute Transaction SFA=Submission in Process STG=Staged SUB=Submitted for Approval XML=Submitted, Pending Validation Default Value: PND
4	EX_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Origin of Entry (Expenses) A=Asset Lifecycle Management H=Mobile Hand Held Device M=Mobile Time and Expense N=NUI P=Primavera P6 W=Web
5	APPROVAL_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Approval Level A=Approver Only B=Pre- and Post-Pay Audit E=Approver & Pre-Pay Auditor I=Approve, Pre- & Post-Pay Audit N=None S=Approver & Post-Pay Auditor T=Auditor Only - Post-Payment U=Auditor Only - Pre-Payment
6	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
7	APPROVAL_DT	Date(10)	DATE	Date of Approval
8	AUDIT_DT	Date(10)	DATE	Date of Audit
9	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
10	SUBMISSION_DATE	Date(10)	DATE	Submission Date
11	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
14	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Default Value: BUS_UNIT_TBL_EX.DST_CNTRL_ID Prompt Table: DST_CNTRL_TBL
15	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
16	ADVANCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Advance Description
17	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
18	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
19	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
20	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
21	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
22	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Default Value: EX_AA_EE_ORG_VW.EMPL_RCD
23	POST_STATUS_EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses Post Status C=Closed M=Marked for Unpost N=Not Applied O=Unpost In Process P=Posted S=Close In Process U=Unposted Default Value: N
24	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
25	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
26	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_A_VW
27	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
28	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
29	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
30	REVERSAL_DATE	Date(10)	DATE	Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
31	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
32	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Default Value: N
33	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose Prompt Table: EX_PURPOSE_TBL
34	RECEIPTS_RECEIVED	Character(1)	VARCHAR2(1) NOT NULL	Receipts Received Y/N Table Edit
35	RCPT_VERIFY_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Verification UserID
36	RCPT_VERIFY_DT	Date(10)	DATE	Date of Verification
37	BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
39	REOCCURRING_ADV	Character(1)	VARCHAR2(1) NOT NULL	Automatic Cash Advance Y/N Table Edit Default Value: N
40	INTERVAL_PERIOD	Number(3,0)	SMALLINT NOT NULL	Cyc Interval (days)
41	BEGIN_DT	Date(10)	DATE	Begin Date
42	END_DT	Date(10)	DATE	End Date
43	RECREATE_DATE	Date(10)	DATE	Auto Submission Date
44	RECREATE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate the status of an Automatic Cash Advance during it's processing cycle.
45	COMMENTS	Long Character	CLOB	Comment
46	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
47	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists Y/N Table Edit Default Value: N