CAR_DATA(SQL Table) |
Index Back |
|---|---|
Car DataContains the attributes about a company car. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CAR_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Car Identification Number used in Administer Company Cars module.
Default Value: 0 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | REGISTRATION_NUM | Character(8) | VARCHAR2(8) NOT NULL | Registration Number |
| 4 | VIN | Character(17) | VARCHAR2(17) NOT NULL | Vehicle Identification Number |
| 5 | MANUFACT_CD | Character(4) | VARCHAR2(4) NOT NULL | Manufacturer |
| 6 | MODEL_DESCR | Character(40) | VARCHAR2(40) NOT NULL |
Model Description
Prompt Table: CAR_MODEL_VW |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL |
| 10 | MGMT_LOCATION_NAME | Character(40) | VARCHAR2(40) NOT NULL |
Location
Prompt Table: CAR_MG_LOC_TBL |
| 11 | COLOUR_CD | Character(3) | VARCHAR2(3) NOT NULL |
Color
BLK=Black BLU=Blue BRW=Brown GRN=Green GRY=Grey PNK=Pink RED=Red SIL=Silver WHT=White YEL=Yellow |
| 12 | REGISTRATION_DT | Date(10) | DATE | Registration Date |
| 13 | PROV_METHOD_CD | Character(1) | VARCHAR2(1) NOT NULL |
Provision Method
C=Contract Hire L=Lease P=Purchase |
| 14 | PROV_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Provision Cost |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 16 | TAX_RENEWAL_DT | Date(10) | DATE | Tax Renewal Date |
| 17 | CLASSIC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Classic Car
Y/N Table Edit Default Value: N |
| 18 | DESCRLONG | Long Character | CLOB | Long Description |