ADMIN_FUNCTIONCOMM_CATEGORYLANGUAGE_CDCOMMCATGSFVWLNG(SQL View) |
Index Back |
|---|---|
Communication Category SF ViewThis view shows Comm Categories for all Institutions |
| SELECT DISTINCT d.admin_function , a.comm_category ,a.language_cd , a.descr , a.descrshort FROM ps_COMM_CATG_LANG a ,PS_COMM_CATG_TBL d WHERE a.effdt = ( SELECT MAX(b.effdt) FROM ps_COMM_CATG_LANG b ,PS_COMM_CATG_TBL e WHERE a.institution = b.institution AND d.admin_function = e.admin_function AND a.comm_category = b.comm_category AND b.effdt <= %CurrentDateIn AND e.eff_status = 'A' AND d.INSTITUTION=e.INSTITUTION AND d.COMM_CATEGORY=e.COMM_CATEGORY AND d.EFFDT=e.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADMIN_FUNCTION |
Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
| 2 | COMM_CATEGORY |
Character(6) | VARCHAR2(6) NOT NULL | Communication Category |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |