SAA_APS_SRC_VW(SQL View) |
Index Back |
|---|---|
Acad Prog Summary Source |
| SELECT ' ' , ' ' , ' ' , 0 , ' ' , ' ' , 0 , 0 , 0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SAA_CAREER_RPT | Character(4) | VARCHAR2(4) NOT NULL | This field is used in academic advisement as a key to the results tables. |
| 4 | ANALYSIS_DB_SEQ | Number(4,0) | SMALLINT NOT NULL | Analysis DB Sequence |
| 5 | TSCRPT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Transcript Type |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | SAA_UNITS_USED | Number(7,2) | DECIMAL(6,2) NOT NULL | This field is used in Academic Advisement to report the number of units used by a requirement. |
| 8 | COLOR | Number(10,0) | DECIMAL(10) NOT NULL | Color |
| 9 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |