INSTITUTIONPROG_REASONEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
SAD_UC_PRSN_VW(SQL View) |
Index Back |
|---|---|
UCAS Program Reason View |
| SELECT b.institution , a.prog_reason , a.effdt , a.eff_status ,a.descr FROM ps_prog_rsn_tbl a , PS_INSTITUTION_TBL b , ps_set_cntrl_rec c WHERE c.setcntrlvalue = b.institution AND c.recname = 'PROG_RSN_TBL' AND c.setid = a.setid AND a.prog_action = 'APPL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | PROG_REASON |
Character(4) | VARCHAR2(4) NOT NULL | Action Reason |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |