SFA_ASG_HSPR_VW(SQL View) |
Index Back |
---|---|
Rigorous High School Programs.View of Rigorous Secondary (High) School Programs of Study. |
SELECT SFA_COD_HS_PROG_CD ,DESCR254 FROM PS_SFA_ASG_HS_PROG WHERE AID_YEAR=( SELECT MAX(A.AID_YEAR) FROM PS_SFA_ASG_HS_PROG A) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SFA_COD_HS_PROG_CD | Character(6) | VARCHAR2(6) NOT NULL | Rigorous High School Program |
2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |