EMPLIDPrompt Table: PEOPLE_SRCH
PLAN_TYPEPrompt Table: SSF_SF_PLTYP_VW
DEDCDPrompt Table: SSF_SF_DED_VW
Prompt Table: PEOPLE_SRCH
SF_PAY_DED_REL(SQL Table) |
Index Back |
|---|---|
Payroll Deduction Relationship |
| # | 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 | PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Prompt Table: SSF_SF_PLTYP_VW |
| 3 | DEDCD |
Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: SSF_SF_DED_VW |
| 4 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL |
Related People ID
Prompt Table: PEOPLE_SRCH |
| 5 | EXPIRE_DT | Date(10) | DATE | Expiration Date |