GPGB_RTIX_AUTH(SQL Table) |
Index Back |
---|---|
RTI XML Authentication DetailsRTI XML Authentication Details. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |