EMPLIDSSR_BR_NMFMT_VW(SQL View) |
Index Back |
|---|---|
BRON Name Format View |
| SELECT NAMES.EMPLID , NAMES.COUNTRY_NM_FORMAT FROM PS_NAMES NAMES , PS_SSR_BR_BO_SETUP SETUP WHERE NAMES.NAME_TYPE = SETUP.SSR_BR_NTGBA_NLD AND %EffdtCheck(NAMES NAMES_ED, NAMES, %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL | Supported Name Format Types |