EX_HDR_SPLIT_VW

(SQL View)
 Index Back

Expense Sheet Header View

View of expense sheet header.

SELECT A.SHEET_ID ,A.EMPLID ,A.SHEET_STATUS ,A.EX_ORIGIN ,A.APPROVAL_LEVEL ,A.CREATION_DT ,A.APPROVAL_DT ,A.AUDIT_DT ,A.AUDIT_OPRID ,A.SUBMISSION_DATE ,A.RESUBMISSION_DT ,A.LASTUPDDTTM ,A.OPRID_LAST_UPDT ,A.RCPT_VERIFY_DT ,A.RCPT_VERIFY_OPRID ,A.RECEIPTS_RECEIVED ,A.RECEIPT_VERIFIED ,A.DST_CNTRL_ID ,A.REFERENCE_ID ,A.SHEET_NAME ,A.COPY_EXPENSE_SHEET ,A.SETID ,A.BUSINESS_UNIT_GL ,A.EMPL_RCD ,A.RECEIPT_ID ,A.POST_STATUS_EX ,A.ADVANCE_ID ,A.ADVANCE_AMT ,A.ACCOUNTING_DT ,A.BUSINESS_PURPOSE ,A.OPRID_ENTERED_BY ,A.COMMENTS ,B.PERCENTAGE ,%subrec(CF16_AN_SBR, B) ,B.PROJECT_ID ,B.DEPTID FROM PS_EX_SHEET_HDR A ,PS_EX_SHEET_SPLIT B WHERE B.SHEET_ID = A.SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

Default Value: NEXT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Report Status
APY=Approved for Payment
APZ=Approved For Zero Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
MFS=Marked for Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
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 RCPT_VERIFY_DT Date(10) DATE Date of Verification
15 RCPT_VERIFY_OPRID Character(30) VARCHAR2(30) NOT NULL Verification UserID
16 RECEIPTS_RECEIVED Character(1) VARCHAR2(1) NOT NULL Receipts Received

Y/N Table Edit

Default Value: N

17 RECEIPT_VERIFIED Character(1) VARCHAR2(1) NOT NULL Receipt Verified

Y/N Table Edit

Default Value: N

18 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
19 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
20 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description
21 COPY_EXPENSE_SHEET Character(1) VARCHAR2(1) NOT NULL Copy From Existing Report
22 SETID Character(5) VARCHAR2(5) NOT NULL SetID
23 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

24 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
25 RECEIPT_ID Character(10) VARCHAR2(10) NOT NULL Receipt ID
26 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
27 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
28 ADVANCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Advance Amount
29 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
30 BUSINESS_PURPOSE Character(5) VARCHAR2(5) NOT NULL Business Purpose

Prompt Table: EX_PURPOSE_TBL

31 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
32 COMMENTS Long Character CLOB Comment
33 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
34 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

35 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

36 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

37 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

38 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

39 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

40 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

41 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

42 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

43 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

44 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

45 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

46 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
47 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW