INSTITUTIONSCC_CAF_ATTRIB_NMSSR_BR_AIRCF_VW(SQL View) |
Index Back |
|---|---|
View for SSR_AIR_HDR CAFView for SSR_AIR_HDR CAF values |
| SELECT DISTINCT A.INSTITUTION , B.SCC_CAF_ATTRIB_NM FROM PS_SSR_AIR_HDR A JOIN PS_SSR_AIR_ADD B ON A.INSTITUTION = B.INSTITUTION AND A.SSR_ITEM_ID = B.SSR_ITEM_ID AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SCC_CAF_ATTRIB_NM |
Character(20) | VARCHAR2(20) NOT NULL | Common Attribute |