RC_CTX905DP_IND(SQL Table) |
Index Back |
|---|---|
Run control for CTX905DP IndRun control for Dental Care Eligibility Load Selected Individuals. |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: PY_COMPANY_VW |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PY_CO_EMP_VW |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PY_CO_EM_RCD_VW |
| 6 | 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 |