SADBPVKCACSRLNG(SQL View) |
Index Back |
---|---|
BPC Accreditation SRFS 15062004 |
SELECT A.EXT_ORG_ID , A.HEGIS_CODE , B.LANGUAGE_CD , B.DESCR FROM PS_SAD_ACC_ORG_NLD A , PS_HEGIS_CODE_LANG B WHERE A.SAD_INTSHP_APP_NLD IN ('AC','IB' ) AND A.START_DATE <= %CurrentDateIn AND (A.END_DATE IS NULL OR A.END_DATE >= %CurrentDateIn) AND A.HEGIS_CODE = B.HEGIS_CODE AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_HEGIS_CODE_TBL B_ED WHERE B.HEGIS_CODE = B_ED.HEGIS_CODE AND B_ED.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
2 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: SAD_BPV_HEG_SRC |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |