SAD_UC_RUNCNTL

(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

Prompt Table: INSTITUTION_TBL

4 SAD_UC_GEN_TRN1 Character(1) VARCHAR2(1) NOT NULL Generate Transactions

Y/N Table Edit

Default Value: Y

5 SAD_UC_EXP_TRN1 Character(1) VARCHAR2(1) NOT NULL Export Transactions to UCAS

Y/N Table Edit

Default Value: Y

6 SAD_UC_UPD_TRN1 Character(1) VARCHAR2(1) NOT NULL Update Transactions from UCAS

Y/N Table Edit

Default Value: N

7 SAD_UC_GEN_TRN2 Character(1) VARCHAR2(1) NOT NULL Generate Transactions

Y/N Table Edit

Default Value: Y

8 SAD_UC_EXP_TRN2 Character(1) VARCHAR2(1) NOT NULL Export Transactions to UTT

Y/N Table Edit

Default Value: Y

9 SAD_UC_UPD_TRN2 Character(1) VARCHAR2(1) NOT NULL Update Transactions from UTT

Y/N Table Edit

Default Value: Y

10 SAD_UC_EXT_ORG Character(1) VARCHAR2(1) NOT NULL Create/Update External Org Rec

Y/N Table Edit

Default Value: Y

11 SAD_UC_IMPORT_LIVE Character(1) VARCHAR2(1) NOT NULL Import Live

Y/N Table Edit