RELATIONSHIPS

(SQL Table)
 Index Back

Relationships

Use RELATIONSHIPS to record information about a person's relationship to other person. You can enter multiple people. The GUARDIAN_RELATIONS field allow you to enter information about the legal relationship to this person, while the PEOPLE_RELATION field identifies the familial or other relationship to the person. For example, a grandparent may legally be a guardian and you would want to capture both these pieces of information about the relationship to the person.

  • Parent Record Of RELATION_AFFIL RELATION_SALU REL_MULT_RECPNT SCC_STG_AFL_WRK SCC_STG_CMM_WRK

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship

    Default Value: NI

    6 GUARDIAN_RELATIONS Character(2) VARCHAR2(2) NOT NULL Guardian Relationship
    LG=Legal Guardian
    NA=Not Applicable
    OT=Other
    PG=Parent Guardian
    SG=Self Guardian
    XG=Primary Guardian

    Default Value: NA

    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID

    Prompt Table: PEOPLE_SRCH

    9 RELATION_NBR_RCP Number(2,0) SMALLINT NOT NULL Reciprocal Relationship Number
    10 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
    11 GUARDIAN_OCC Character(10) VARCHAR2(10) NOT NULL Guardian Occupation

    Prompt Table: US_SOC_TBL

    12 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    13 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    14 RELATIONS_INCOME Number(9,0) DECIMAL(9) NOT NULL Relations Income
    15 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    16 RESIDENCY_DT Date(10) DATE Residency Date
    17 STATE_RESIDENCY Character(6) VARCHAR2(6) NOT NULL State of Residency

    Prompt Table: STATE_RES_VW

    18 COUNTRY_RESIDENCY Character(3) VARCHAR2(3) NOT NULL Country of Residency

    Default Value: INSTALLATION.COUNTRY

    Prompt Table: COUNTRY_TBL

    19 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country

    Prompt Table: SCC_NIDCTY_VW

    20 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Prompt Table: REL_NID_TYPE_VW

    21 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    24 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    25 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    26 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    27 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    28 CITY Character(30) VARCHAR2(30) NOT NULL City
    29 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    30 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    31 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    32 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    33 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    34 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    35 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    36 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    37 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    38 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    39 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    40 CHG_ADDR Character(1) VARCHAR2(1) NOT NULL Address Changed

    Y/N Table Edit

    Default Value: N

    41 CHG_OTHER Character(1) VARCHAR2(1) NOT NULL Other Changed

    Y/N Table Edit

    Default Value: N

    42 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: HCR_NM_PREFIX_I

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

    Prompt Table: HCR_NM_SUFFIX_I

    44 SALUTATION Character(20) VARCHAR2(20) NOT NULL Salutation

    Prompt Table: SALUTATION_TBL

    45 CONTACT_THRU Number(2,0) SMALLINT NOT NULL Contact Thru

    Prompt Table: REL_CONTACT_VW

    46 PHONE_DAY Character(30) VARCHAR2(30) NOT NULL Daytime Telephone
    47 PHONE_EVE Character(30) VARCHAR2(30) NOT NULL Evening Telephone
    48 PHONE_FAX Character(30) VARCHAR2(30) NOT NULL Fax Nbr
    49 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    50 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address
    51 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    52 CITIZEN_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country of Citizenship

    Prompt Table: COUNTRY_TBL

    53 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: SCC_CTZN_STS_I
    Set Control Field: CITIZEN_COUNTRY

    54 ALL_COMMUNICATIONS Character(1) VARCHAR2(1) NOT NULL All Communications

    Y/N Table Edit

    Default Value: N

    55 COMMENTS Long Character CLOB Comment
    56 JOINT_RECORD Character(1) VARCHAR2(1) NOT NULL Create Joint Records

    Y/N Table Edit

    Default Value: N

    57 JOINT_ADDRESS Character(1) VARCHAR2(1) NOT NULL Joint Address

    Y/N Table Edit

    Default Value: N

    58 JOINT_ADDRESS_RCP Character(1) VARCHAR2(1) NOT NULL Joint Address

    Y/N Table Edit

    Default Value: N

    59 ADDR_TYPE3 Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: RELATED_ADDR_VW

    60 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: ADDRESSES_EFFVW

    61 DISSOLVE_REASON Character(2) VARCHAR2(2) NOT NULL Dissolution Reason
    DI=Divorce
    DP=Deceased Partner
    LA=Leave of Absence
    LD=Long Term Disability
    MV=Move
    OT=Other
    PR=Per Request
    SP=Separation
    62 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other

    Prompt Table: HCR_EMAIL_ADD_I

    63 E_ADDR_TYP2 Character(4) VARCHAR2(4) NOT NULL Email Address Type
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    PREF=Preferred

    Prompt Table: RELATED_EADDR_V

    64 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL