Body
SCC_NAMES_QVW is a version of the Names tables delivered by PeopleSoft for use in Campus Solutions Queries
Detailed Information
Data Systems
PeopleSoft Campus Solutions - CSPRD
PeopleSoft Campus Solutions Reporting - CSRPT
| Key |
Record.Fieldname |
Format |
XLAT |
Heading Text |
| |
COUNTRY_NM_FORMAT - Format Using |
Char3 |
|
Use |
| Key |
EFFDT - Effective Date |
Date |
|
Eff Date |
| |
EFF_STATUS - Status as of Effective Date |
Char1 |
N |
Status |
| Key |
EMPLID - Empl ID |
Char11 |
|
ID |
| |
FIRST_NAME - First Name |
Char30 |
|
First Name |
| |
FIRST_NAME_SRCH - First Name |
Char30 |
|
First Name |
| |
LAST_NAME - Last Name |
Char30 |
|
Last |
| |
LAST_NAME_PREF_NLD - Last Name Preference |
Char1 |
N |
Preference |
| |
LAST_NAME_SRCH - Last Name |
Char30 |
|
Last |
| |
MIDDLE_NAME - Middle Name |
Char30 |
|
Middle |
| |
NAME - Name |
Char50 |
|
Name |
| |
NAME_AC - Alternate Character Name |
Char50 |
|
AC Name |
| |
NAME_DISPLAY - Display Name |
Char50 |
|
Display Name |
| |
NAME_FORMAL - Formal Name |
Char60 |
|
Formal Name |
| |
NAME_INITIALS - Name Initials |
Char6 |
|
Initials |
| |
NAME_PREFIX - Name Prefix |
Char4 |
|
Prefix |
| |
NAME_ROYAL_PREFIX - Name Royal Prefix |
Char15 |
|
Royal Prefix |
| |
NAME_ROYAL_SUFFIX - Name Royal Suffix |
Char15 |
|
Royal Suffix |
| |
NAME_SUFFIX - Name Suffix |
Char15 |
|
Suffix |
| |
NAME_TITLE - Title |
Char30 |
|
Title |
| Key |
NAME_TYPE - Type of Name |
Char3 |
|
Name Type |
| |
PARTNER_LAST_NAME - Last Name Partner |
Char30 |
|
Last Name |
| |
PARTNER_ROY_PREFIX - Prefix Partner |
Char15 |
|
Prefix |
| |
PREF_FIRST_NAME - Preferred First Name |
Char30 |
|
Preferred First |
| |
SECOND_LAST_NAME - Second Last Name |
Char30 |
|
Second Last |
| |
SECOND_LAST_SRCH - Second Name |
Char30 |
|
Second Name |