PLAN_TYPEBENEFIT_PLANPrompt Table: BENEF_PLAN_TBL
EFFDTDefault Value: %date
D=Days
M=Months
W=Weeks
Y=Years
Default Value: M
Prompt Table: CURRENCY_CD_TBL
CAR_PLAN_TBL(SQL Table) |
Index Back |
|---|---|
Company Car Plan TableUsed in the Company Car application. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | QUALIFY_PD | Number(2,0) | SMALLINT NOT NULL | Qualifying Period |
| 5 | QUALIFY_LENGTH | Character(1) | VARCHAR2(1) NOT NULL |
Length of time to qualify
D=Days M=Months W=Weeks Y=Years Default Value: M |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | ALLOWANCE_AMT | Number(6,0) | INTEGER NOT NULL | Allowance Amount |
| 8 | MAX_LIST_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Max List Price |
| 9 | MAX_LEASE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Max Lease Price |
| 10 | MAX_HIRE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Max Contract Hire Price |
| 11 | MIN_LIST_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Min List Price |
| 12 | MIN_LEASE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Min Lease Price |
| 13 | MIN_HIRE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Min Contract Hire Price |