BEN_BI_RUNCTL(SQL Table) |
Index Back |
|---|---|
Ben Billing RunCtlBEN_BI_RUNCTL is a record used by the Benefits Billing Calculation COBOL program. This run control must be set up to trigger processing. Update this record on-line with the Calculate Billing Run Control panel. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BILL_PER_CD | Character(4) | VARCHAR2(4) NOT NULL |
Billing Period
Prompt Table: BEN_BI_CALENDAR |
| 4 | BILL_DUE | Date(10) | DATE NOT NULL |
Payment Due
Default Value: BEN_BI_CALENDAR.BILL_DUE |
| 5 | COBRA_DUE | Date(10) | DATE NOT NULL |
COBRA Payment Due
Default Value: BEN_BI_CALENDAR.COBRA_DUE |
| 6 | PROCESS_DT | Date(10) | DATE NOT NULL |
Process Date
Default Value: %date |
| 7 | CHKPT_INTERVAL | Number(5,2) | DECIMAL(4,2) NOT NULL | Chk Point Interval in Minutes |
| 8 | BILL_PROC_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
Billing Processing Phase
B=Calculating Billing C=Applying Open Credits F=Final Updates P=Purging Old Calculations R=Ready for Processing Default Value: R |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | BILL_PAY_ID | Number(7,0) | INTEGER NOT NULL | Payment ID |