SCC_NM_TYPE2PVW

(SQL View)
 Index Back

Employee Name Types

NAME_TYPE_VW is a view of NAMES that allows for a level 1 scroll that controls the NAME_TYPES.

SELECT DISTINCT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID ,B.ORDER_BY_SEQ ,A.NAME_TYPE ,A.AUDIT_ACTN FROM PS_SCC_NAMES_STG A , PS_NAME_TYPE_TBL B WHERE A.NAME_TYPE = B.NAME_TYPE

  • Parent record: PERSON

    • # 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

    Prompt Table: PERSON

    5 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence
    6 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    7 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