HRS_CONTACT_IDLANGUAGE_CDHRS_REC_SC_L_I(SQL View) |
Index Back |
|---|
| SELECT A.HRS_CONTACT_ID , A.LANGUAGE_CD , A.HRS_CONTACT_LDESCR , A.HRS_CONTACT_SDESCR FROM PS_HRS_CONTACT_LNG A , PS_HRS_CONTACT B WHERE B.HRS_CONTACT_TYPE='20' AND A.HRS_CONTACT_ID=B.HRS_CONTACT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_CONTACT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Contact ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | HRS_CONTACT_LDESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | HRS_CONTACT_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Short Description |