INSTITUTIONSCC_AFL_CODESCC_AFL_CHLD_CODESSR_AFL_CHLD_VW(SQL View) |
Index Back |
|---|---|
Child Affiliation codes view |
| SELECT b.INSTITUTION ,b.SCC_AFL_CODE ,B.SCC_AFL_CHLD_CODE ,a.scc_afl_chldrn , a.scc_afl_is_root ,A.SCC_AFL_DESCR FROM PS_SCC_AFL_TBL A ,PS_SCC_AFL_CHDRN B WHERE A.SCC_AFL_CODE = B.SCC_AFL_chld_CODE AND A.INSTITUTION = B.INSTITUTION AND A.EFFDT = B.scc_afl_chld_EFFDT AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_AFL_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.SCC_AFL_CODE = A.SCC_AFL_CODE AND A1.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SCC_AFL_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Affiliations Code |
| 3 | SCC_AFL_CHLD_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Child Affiliation Code |
| 4 | SCC_AFL_CHLDRN | Character(1) | VARCHAR2(1) NOT NULL | Flag that indicates if an affiliation has child affiliations. Maintained by the system and used by the Affiliation Manager to make processing more effecient. |
| 5 | SCC_AFL_IS_ROOT | Character(1) | VARCHAR2(1) NOT NULL | Root Affiliation code |
| 6 | SCC_AFL_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Affiliations Long Description |