EMPLIDPrompt Table: PERSON
SSR_NAME_TYPE_ADDPrompt Table: NAME_TYPE_TBL
EFFDTDefault Value: %date
A=Active
I=Inactive
SSR_GR_NAME_VW(SQL View) |
Index Back |
|---|---|
Grad App Name View |
| SELECT N.EMPLID ,N.NAME_TYPE ,N.EFFDT ,T.NAME_TYPE_DESCR ,N.EFF_STATUS ,N.COUNTRY_NM_FORMAT ,N.NAME_DISPLAY ,N.NAME_PREFIX ,N.FIRST_NAME ,N.MIDDLE_NAME ,N.LAST_NAME ,N.NAME_SUFFIX ,N.EFFDT FROM PS_NAMES N , PS_NAME_TYPE_TBL T WHERE T.NAME_TYPE = N.NAME_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | SSR_NAME_TYPE_ADD |
Character(3) | VARCHAR2(3) NOT NULL |
Name Type
Prompt Table: NAME_TYPE_TBL |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | NAME_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Name Type |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL | Supported Name Format Types |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 11 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 12 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 13 | ASOFDATE | Date(10) | DATE | As of Date |