SSF_RFNDAPP_AET

(SQL Table)
Index Back

Refund Approval

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SF_DATETIME DateTime(26) TIMESTAMP SF DateTime
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BATCH_ID_LAST_PP Character(12) VARCHAR2(12) NOT NULL Batch ID
7 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
8 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
9 OPRID2 Character(30) VARCHAR2(30) NOT NULL User ID
10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
12 REF_APPR_ACTIVE_SW Character(1) VARCHAR2(1) NOT NULL Activate On-line Approvals
13 REF_APPR_SW_1 Character(1) VARCHAR2(1) NOT NULL Approval Switch 1
A=Refund Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval
14 REF_APPR_SW_2 Character(1) VARCHAR2(1) NOT NULL Approval Switch 2
A=Refund Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval
15 REF_APPR_SW_3 Character(1) VARCHAR2(1) NOT NULL Approval Switch 3
A=Approved
D=Refund Denied
N=No Approval Required
P=Pending Approval