REPORT_REQUEST_NBRINSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
TSCRPT_TYPEDefault Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE
Prompt Table: SAA_SCRTY_AA_VW
EMPLIDPrompt Table: STDNT_SRCH
SAA_RPTRQST_DTL(SQL Table) |
Index Back |
|---|---|
Report Request DetailsAcademic Advisement Report Request Details record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_REQUEST_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Report Request Nbr |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | TSCRPT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Transcript Type
Default Value: OPR_DEF_TBL_CS.SAA_TSCRPT_TYPE Prompt Table: SAA_SCRTY_AA_VW |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STDNT_SRCH |
| 5 | ANALYSIS_DB_SEQ | Number(4,0) | SMALLINT NOT NULL | Analysis DB Sequence |