EMPLIDPrompt Table: PERSON
DEPENDENT_BENEF01=default
Prompt Table: DEPENDENT_VW
PLAN_TYPEPrompt Table: DEPBEN_PLNRDRVW
START_DTEFFSEQA=Active
I=Inactive
Default Value: A
Prompt Table: STATE_TBL
C=Court Order
S=Spousal Waiver
Default Value: C
DEPBEN_RIDER(SQL Table) |
Index Back |
|---|---|
Depend/Benef Court OrdersBEN_COURT_ORDER is used to record dependents/beneficiary court orders. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |
| 3 | 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: DEPBEN_PLNRDRVW |
| 4 | START_DT |
Date(10) | DATE NOT NULL | Start Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 9 | BEN_COURT_ORDR_NUM | Character(30) | VARCHAR2(30) NOT NULL | Court Order Number |
| 10 | COMMENTS | Long Character | CLOB | Comment |
| 11 | RIDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates what type of regulatory Rider is being defined. Typical values are Court Orders and Spousal Waivers.
C=Court Order S=Spousal Waiver Default Value: C |