EX_CA_HDR_AW_VW (SQL View)	Index Back
Cash Advance Header View Used for Appr

EX_CA_HDR_AW_VW

(SQL View)

Cash Advance Header View

Used for Appr

SELECT ADVANCE_ID , EMPLID , ADV_STATUS , CREATION_DT , APPROVAL_DT , SUBMISSION_DATE , RESUBMISSION_DT , LASTUPDDTTM , OPRID_LAST_UPDT , ADVANCE_NAME , OPRID_ENTERED_BY , SETID , BUSINESS_UNIT_GL , TOTAL_AMT , CURRENCY_CD FROM PS_EX_ADV_HDR

# 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 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

5 APPROVAL_DT Date(10) DATE Date of Approval

6 SUBMISSION_DATE Date(10) DATE Submission Date

7 RESUBMISSION_DT Date(10) DATE Resubmission Date

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

9 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

10 ADVANCE_NAME Character(30) VARCHAR2(30) NOT NULL Advance Description

11 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

12 SETID Character(5) VARCHAR2(5) NOT NULL SetID

13 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

14 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
5	APPROVAL_DT	Date(10)	DATE	Date of Approval
6	SUBMISSION_DATE	Date(10)	DATE	Submission Date
7	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
8	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.
9	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
10	ADVANCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Advance Description
11	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
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
14	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code