RC_CTX905DP(SQL Table) |
Index Back |
|---|---|
Run control for CTX905DPRun control for Dental Care Eligibility Load. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | DATE1 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | CAN_ELIGIBILITY_LD | Character(1) | VARCHAR2(1) NOT NULL |
Options to load eligibility by for the canadian dental eligibility load program.
C=By Company G=By Group ID I=For Selected Individuals Default Value: C |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 7 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 8 | CAN_DEN_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Level of access for Dental Cares Eligibility.
1=No Dental Access or coverage 2=Payee 3=Payee, Spouse and Dependents 4=Payee and Spouse 5=Payee and Dependents |