EX_CMRK_SRCH_VW

(SQL View)
Index Back

Close Cash Advance


SELECT A.ADVANCE_ID , A.ADVANCE_NAME , B.NAME , A.EMPLID , A.ADV_STATUS , A.CREATION_DT FROM PS_EX_ADV_HDR A , PS_PERSONAL_DATA B WHERE A.POST_STATUS_EX = 'P' AND (A.ADV_STATUS = 'APY' OR (A.ADV_STATUS = 'PD' AND NOT EXISTS ( SELECT 'X' FROM PS_EX_ADVNCE_PYMNT C WHERE C.ADVANCE_ID = A.ADVANCE_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_HDR D WHERE D.CREDIT_ADV = A.ADVANCE_ID))) AND B.EMPLID = A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
2 ADVANCE_NAME Character(30) VARCHAR2(30) NOT NULL Advance Description
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

5 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
6 CREATION_DT Date(10) DATE Creation Date