CPS_SCHOOL_CODESFA_NSLDS_SCHVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.CPS_SCHOOL_CODE ,A.INSTIT_OE_BR FROM PS_NSLDS_HDR_IN_EC A , PS_ECQUEUE QUEUE WHERE QUEUE.ECTRANSID IN ('TRALRTOP', 'FAHEXTOP') AND QUEUE.ECTRANSINOUTSW = 'I' AND QUEUE.ECQUEUESTATUS='L' AND A.ECTRANSID = QUEUE.ECTRANSID AND A.ECQUEUEINSTANCE = QUEUE.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = QUEUE.ECTRANSINOUTSW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CPS_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 2 | INSTIT_OE_BR | Character(2) | VARCHAR2(2) NOT NULL | Branch Code |