GPGB_RTIX_AUTH

(SQL Table)
Index Back

RTI XML Authentication Details

RTI XML Authentication Details.

  • Parent Record Of GPGB_RTIX_SCH_H
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    2 GPGB_RTIX_SNDRID Character(100) VARCHAR2(100) NOT NULL RTI XML Sender ID
    3 GPGB_RTIX_AUTHMTH Character(4) VARCHAR2(4) NOT NULL Authentication Method
    CLEA=Clear
    MD5=MD5
    4 GPGB_RTIX_ROLE Character(50) VARCHAR2(50) NOT NULL RTI XML Header- Role
    5 GPGB_RTIX_PSWD Character(254) VARCHAR2(254) NOT NULL RTI XML Header Password
    6 GPGB_RTIX_EMAIL Character(129) VARCHAR2(129) NOT NULL RTI XML Header- Email
    7 GPGB_RTIX_CNT_FLD Character(4) VARCHAR2(4) NOT NULL RTI XML Contact Field
    AGEN=Agent
    PRIN=Principal
    8 GPGB_RTIX_SNDR_FLD Character(4) VARCHAR2(4) NOT NULL RTI XML Header Sender Field
    ACTG=Acting in Capacity
    AGEN=Agent
    BURE=Bureau
    COMP=Company
    EMPR=Employer
    GOVR=Government
    IND=Individual
    OTHR=Other
    PART=Partnership
    TRUS=Trust
    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GPGB_RTIX_DVW

    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: GPGB_RTIXVND_VW