SAA_RC_RPTPRINT

(SQL Table)
Index Back

Batch AA Report Run Control

This record is used to store values to be used by the batch advisement report batch print process.

# 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 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

Default Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE

Prompt Table: SAA_SCRTY_AAVW2

5 SAA_RPT_DT_FROM Date(10) DATE This field is used for selecting a from date to be used in a date range on the batch generation run control page.
6 SAA_RPT_DT_TO Date(10) DATE This field is used for selecting a to date to be used in a date range on the batch generation run control page.
7 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.

Prompt Table: SAA_IDENT_TBL