SFA_COD_PROGCIP_CDSFA_ASG_CIP_VW(SQL View) |
Index Back |
|---|---|
Program CIP CodesView of Program CIP Code. |
| SELECT SFA_COD_PROGCIP_CD ,DESCR254 FROM PS_SFA_ASG_CIP_CD WHERE AID_YEAR=( SELECT MAX(A.AID_YEAR) FROM PS_SFA_ASG_CIP_CD A) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_COD_PROGCIP_CD |
Character(7) | VARCHAR2(7) NOT NULL | SMART Eligible CIP Code |
| 2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |