[Home] [Help]
View: IGS_EN_NSC_BRANCH_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view picks up the branch code for National Student Clearing House creation process. This is used in the value set of concurrent process. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT RPAD(ALT.ORG_ALTERNATE_ID
, 20)||' '||ALT.ORG_ALTERNATE_ID_TYPE ALTERNATE_ID
, ALT.ORG_ALTERNATE_ID ||' '||ALT.ORG_ALTERNATE_ID_TYPE ALTERNATE_ID_TYPE
FROM IGS_OR_ORG_ALT_IDS_V ALT
WHERE ALT.ORG_STRUCTURE_TYPE = 'ORG_UNIT'
AND NVL(ALT.END_DATE
, SYSDATE) >= SYSDATE UNION SELECT RPAD('00'
, 20)||' '||'00' ALTERNATE_ID
, '00 00' ALTERNATE_ID_TYPE
FROM DUAL
Columns
| Name |
| ALTERNATE_ID |
| ALTERNATE_ID_TYPE |