RELATION_SALU

(SQL Table)
Index Back

Relationship salutation

Relationship Salutation types

  • Parent record: RELATIONSHIPS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SALUTATION_TYPE Character(3) VARCHAR2(3) NOT NULL Salutation Type

    Prompt Table: %EDITTABLE

    5 JOINT_SALU1 Character(120) VARCHAR2(120) NOT NULL Joint Salutation 1
    6 JOINT_SALU2 Character(120) VARCHAR2(120) NOT NULL Joint Salutation 2
    7 JOINT_ADDR_NAME1 Character(120) VARCHAR2(120) NOT NULL Address Block name 1
    8 JOINT_ADDR_NAME2 Character(120) VARCHAR2(120) NOT NULL Address Block name 2