COMPANYEFFDTDefault Value: %DATE
Prompt Table: CPS_ORG_ID_TBL
B=Batch
T=Transmission
Prompt Table: CPS_ORG_ID_TBL
CPS_CAMP_TBL(SQL Table) |
Index Back |
|---|---|
CPS Campaign Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
| 3 | END_DT | Date(10) | DATE NOT NULL | end date |
| 4 | CPS_ORG_ID | Number(5,0) | INTEGER NOT NULL |
Employer Organization ID
Prompt Table: CPS_ORG_ID_TBL |
| 5 | CPS_MIN_CONTRIB | Number(6,2) | DECIMAL(5,2) NOT NULL | Min. Weekly Contribution Limit |
| 6 | CPS_PAYMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
B=Batch T=Transmission |
| 7 | XMIT_ORG_ID | Number(5,0) | INTEGER NOT NULL |
Transmitter Organization ID
Prompt Table: CPS_ORG_ID_TBL |