XMLFILE_IDDefault Value: XML_DEFN.XMLFILE_ID
EMPLIDPrompt Table: PERS_SRCH_GBL
COMPANYPrompt Table: COMPANY_TBL
SSN_EMPLOYERPrompt Table: GPES_SS_WC_VW
RC_CTTA_ESP(SQL Table) |
Index Back |
|---|---|
SSN EmployerSSN Employer |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | XMLFILE_ID |
Character(50) | VARCHAR2(50) NOT NULL |
XML File ID
Default Value: XML_DEFN.XMLFILE_ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 4 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table: GPES_SS_WC_VW |