RUNCTL_FAISRPRT

(SQL Table)
Index Back

# 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

Prompt Table: FASAREXX_AYR_VW

5 SCC_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update switch
N=No
Y=Yes

Default Value: Y

6 ISIR_TOTAL_RECSOUT Number(9,0) DECIMAL(9) NOT NULL Total Number of Records Output
7 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance