RUNCNTL_ASG876

(SQL Table)
Index Back

ACG/SMART Orig/Tran Status Rpt

ACG/SMART Origination/Transmit Status Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: FED_AID_YR_TBL

5 SFA_ASG_ORIG_STAT Character(1) VARCHAR2(1) NOT NULL ACG/SMART Orig Status
A=Accepted
C=Corrected
O=Originated
R=Rejected
T=Transmitted
U=Change to Orig
X=Cancelled
6 SFA_COD_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL COD Transmit Status
C=Review
H=On Hold
R=Ready
T=Transmitted
X=Cancel