SCC_NAMES_STG

(SQL Table)
Index Back

Name change messaging table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCC_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequence ID
3 SCC_SEQ_ID3 Number(3,0) SMALLINT NOT NULL Sequence Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
6 EFFDT Date(10) DATE NOT NULL Effective Date
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT

Prompt Table: NAME_FORMAT_TBL

9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
11 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

Prompt Table: NAME_PREFIX_TBL

12 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

Prompt Table: NAME_SUFFIX_TBL

13 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

Prompt Table: NM_ROYPREF_GBL

14 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

Prompt Table: NM_ROYSUFF_GBL

15 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

Prompt Table: TITLE_TBL

16 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
17 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
18 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
19 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
20 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
21 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
22 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
23 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
24 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
25 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
26 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

Prompt Table: NM_ROYPREF_GBL

27 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

Default Value: 1

28 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
29 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
30 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
32 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values