OPRCLASSCOMMON_IDPrompt Table: PEOPLE_SRCH
TRACKING_SEQLANGUAGE_CDTRCKING_SRCH_LN(SQL View) |
Index Back |
|---|---|
TRCKING_SRCH_LNThis is the Related Language view for TRACKING_SRCH |
| SELECT c.oprclass , a.common_id , a.tracking_seq , e.language_cd , c.country , c.national_id_type , e.descrshort , c.national_id FROM ps_tracking_grps a , PS_SCC_PRI_NAME_VW b , ps_pers_nid_msk_vw c , PS_NID_TYPE_TBL d ,ps_nid_type_lang e WHERE a.common_id = b.emplid AND a.common_id = c.emplid AND d.country = c.country AND d.country = e.country AND d.national_id_type = c.national_id_type AND d.national_id_type = e.national_id_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
Prompt Table: PEOPLE_SRCH |
| 3 | TRACKING_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tracking Sequence |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 6 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 7 | NID_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | NID Short Description |
| 8 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |