SAA_RPT_TYP_PRG(SQL Table) |
Index Back |
|---|---|
Valid Report Program StatusesThis table contains all the valid program statuses for a particular advisement report type. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | TSCRPT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Transcript Type |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | PROG_STATUS |
Character(4) | VARCHAR2(4) NOT NULL |
Academic Program Status
AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted Prompt Table: SAA_PROG_ST_VW |