SALU_TYPE_TBL

(SQL Table)
 Index Back

Salutation Type table

  • Parent Record Of NAME1_ORDER_TBL NAME2_ORDER_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SALUTATION_TYPE Character(3) VARCHAR2(3) NOT NULL Salutation Type
    2 SALU_USAGE Character(3) VARCHAR2(3) NOT NULL Salutation Type Usage
    BLO=Address Block Name
    SAL=Salutation Name

    Default Value: SAL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 SEP_LINE_FLAG Character(1) VARCHAR2(1) NOT NULL Two separate lines

    Y/N Table Edit

    Default Value: N

    6 NAME1_SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: U

    7 NAME1_SALUTATION Character(20) VARCHAR2(20) NOT NULL Salutation for Name1

    Prompt Table: SALUTATION_TBL

    8 NAME2_SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown

    Default Value: U

    9 NAME2_SALUTATION Character(20) VARCHAR2(20) NOT NULL Salutation for Name2

    Prompt Table: SALUTATION_TBL