EX_ADV_PRMPT_VW

(SQL View)
Index Back

Advance Prompt

Cash Advance Prompt view for assigning advances to a sheet.

SELECT DISTINCT A.EMPLID, A.ADVANCE_ID, A.ADVANCE_NAME, A.ADV_STATUS FROM PS_EX_ADV_HDR A WHERE A.ADV_STATUS = 'PD' AND NOT EXISTS (SELECT 'X' FROM PS_EX_SHEET_HDR X WHERE X.ADVANCE_ID = A.ADVANCE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
3 ADVANCE_NAME Character(30) VARCHAR2(30) NOT NULL Advance Description
4 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