BEN_SEC_CONT_VW

(SQL View)
 Index Back

Benefit Administrative Contact

This record is used to record internal company contact information for benefit plans, such as Plan Administrator, COBRA Administrator, HIPAA Administrator, etc.

SELECT BENEF_CONTACT_ID , BN_CONTACT_DESCR , CONTACT_NAME , BUSINESS_TITLE , EMAILID , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , COUNTY , STATE , POSTAL , COUNTRY_CODE , PHONE , EXTENSION FROM PS_BEN_CONTACT_TBL WHERE SUPPORT_IND = 'S' AND EFF_STATUS = 'A'

  • Parent record: BEN_CONTACT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BENEF_CONTACT_ID Number(3,0) SMALLINT NOT NULL Used to identify a contact name/address

    Default Value: 1

    2 BN_CONTACT_DESCR Character(30) VARCHAR2(30) NOT NULL Contact Description used for administrative contacts for benefits.
    3 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    4 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    13 STATE Character(6) VARCHAR2(6) NOT NULL State
    14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    15 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
    16 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    17 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension