REQUIREMENTPrompt Table: RQ_MAIN_TBL
EFFDTDefault Value: %date
RQ_LINE_KEY_NBRPrompt Table: RQ_LINE_TBL
LANGUAGE_CDDefault Value: RQ_LINE_LANG.DESCR
RQ_LINE_LANG(SQL Table) |
Index Back |
|---|---|
Language Tbl for Rq LineTableThis is the language table for the Requirement Line table, RQ_LINE_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REQUIREMENT |
Character(9) | VARCHAR2(9) NOT NULL |
Academic Requirement
Prompt Table: RQ_MAIN_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RQ_LINE_KEY_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Background Key
Prompt Table: RQ_LINE_TBL |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: RQ_LINE_LANG.DESCR |
| 7 | SAA_DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This field is used to display information in the new student view for academic advisement reports. |
| 8 | DESCR254A | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 9 | SAA_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | This field is used to display information in the new student view for academic advisement reports. |
| 10 | SAA_DESCRLONG | Long Character | CLOB | This field is used to display information in the new student view for academic advisement reports. |