PARK PERMIT TYPE Table
View exposing parking permit type reference records including permit definitions, eligibility rules, payment attributes, and operational constraints.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALLOW_AS_ADDITIONAL |
Indicator identifying whether as additional (Y/N). |
VARCHAR2 |
1 |
ALLOW_CREDIT_CARD |
Indicator identifying whether credit card (Y/N). |
VARCHAR2 |
1 |
ALLOW_JOURNAL_VOUCHER |
Indicator identifying whether journal voucher (Y/N). |
VARCHAR2 |
1 |
ALLOW_LOCATION_CHANGE |
Indicator identifying whether location change (Y/N). |
VARCHAR2 |
1 |
ALLOW_OFF_CAMPUS |
Indicator identifying whether off campus (Y/N). |
VARCHAR2 |
1 |
ALLOW_PAYROLL_DEDUCT |
Indicator identifying whether payroll deduct (Y/N). |
VARCHAR2 |
1 |
ALLOW_STUDENT_ACCOUNT |
Indicator identifying whether student account (Y/N). |
VARCHAR2 |
1 |
DEFAULT_LOCATION |
Default location associated with the record. |
VARCHAR2 |
60 |
ELIGIBILITY_FUNCTION |
Eligibility function associated with the record. |
VARCHAR2 |
30 |
EVAL_ORDER |
Eval order associated with the record. |
VARCHAR2 |
2 |
HEADER_TEXT_HTML |
Header text html associated with the record. |
VARCHAR2 |
70 |
IS_PERMIT_ACTIVE |
Indicator identifying whether permit active (Y/N). |
VARCHAR2 |
1 |
LOCATION_SECTION_HEADER |
Location section header associated with the record. |
VARCHAR2 |
128 |
MAX_TMP_VEHICLES_ON_PERMIT |
Max tmp vehicles on permit associated with the record. |
NUMBER |
34 |
MAX_VEHICLES_ON_PERMIT |
Max vehicles on permit associated with the record. |
NUMBER |
34 |
MIN_VEHICLES_ON_PERMIT |
Min vehicles on permit associated with the record. |
NUMBER |
34 |
PARKING_PERMIT_TYPE_ID |
Business identifier for the parking permit type. |
VARCHAR2 |
4 |
PERMIT_DEFAULT_VALIDITY |
Permit default validity associated with the record. |
VARCHAR2 |
60 |
PERMIT_DESCRIPTION |
Description of permit. |
VARCHAR2 |
128 |
PERMIT_NAME |
Permit name associated with the record. |
VARCHAR2 |
60 |
PERMIT_TYPE |
Permit type associated with the record. |
VARCHAR2 |
60 |
REQUIRE_EMAIL |
Require email associated with the record. |
VARCHAR2 |
1 |
REQUIRE_END_DATE |
Date associated with require end. |
VARCHAR2 |
1 |
REQUIRE_PHONE_NUM |
Require phone num associated with the record. |
VARCHAR2 |
1 |
REQUIRE_REQUESTOR |
Indicator identifying whether requestor (Y/N). |
VARCHAR2 |
1 |
REQUIRE_START_DATE |
Date associated with require start. |
VARCHAR2 |
1 |
SHOW_LOCATION_INPUT |
Indicator identifying whether location input (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |