COMMON_IDORG_LOCATIONEFFDTLANGUAGE_CDORG_LOCVW2_LANG(SQL View) |
Index Back |
|---|---|
ORG_LOCVW2_LANGRelated Language for ORG_LOCATIONVW2 |
| SELECT A.EXT_ORG_ID , A.ORG_LOCATION , A.EFFDT , A1.LANGUAGE_CD , A1.DESCR FROM PS_ORG_LOCATION A ,PS_ORG_LOC_LANG A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A.ORG_LOCATION = A1.ORG_LOCATION AND A.EFFDT = A1.EFFDT AND %EffdtCheck(ORG_LOC_LANG A2, A1, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 2 | ORG_LOCATION |
Number(3,0) | SMALLINT NOT NULL | Location Nbr |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |