SAE_LDAPADUSGLN(SQL View) |
Index Back |
---|---|
Address usage related languageRelated Language Address Usage View used by SAIP LDAP |
SELECT A.EMPLID ,A.ADDR_USAGE ,B.LANGUAGE_CD ,B.ADDR_TYPE_DESCR FROM %Table(SCC_EQAD_USG_VW) A , %Table(ADDRESS_TYP_LNG) B WHERE B.ADDRESS_TYPE = A.ADDRESS_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
2 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | ADDR_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Address Type |