PARK TX PAYMENT Table
View exposing parking payment transaction records including payment methods, statuses, financial attributes, authorization details, and audit information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNTING_DOCUMENT_NUMBER |
Accounting document number associated with the record. |
VARCHAR2 |
10 |
ADJ_ITEM |
Adj item associated with the record. |
VARCHAR2 |
4 |
AMOUNT_REQUESTED |
Amount requested associated with the record. |
NUMBER |
9,2 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_OBJECT |
Cost object associated with the record. |
VARCHAR2 |
12 |
CREATED_AT |
Time associated with created. |
VARCHAR2 |
6 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CREATED_ON |
Date associated with created. |
DATE |
|
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
CYBERSOURCE_AUTH_CODE |
Code identifying cybersource auth. |
VARCHAR2 |
16 |
CYBERSOURCE_AUTH_DATE |
Date associated with cybersource auth. |
DATE |
|
CYBERSOURCE_AUTH_REASON_CD |
Cybersource auth reason cd associated with the record. |
VARCHAR2 |
3 |
CYBERSOURCE_AUTH_RECON_CD |
Cybersource auth recon cd associated with the record. |
VARCHAR2 |
16 |
CYBERSOURCE_AUTH_TIME |
Time associated with cybersource auth. |
VARCHAR2 |
6 |
CYBERSOURCE_AVS_CODE |
Code identifying cybersource avs. |
VARCHAR2 |
1 |
CYBERSOURCE_CAPTURE_DATE |
Date associated with cybersource capture. |
DATE |
|
CYBERSOURCE_CAPTURE_REASON_CD |
Cybersource capture reason cd associated with the record. |
VARCHAR2 |
3 |
CYBERSOURCE_CAPTURE_RECON_CD |
Cybersource capture recon cd associated with the record. |
VARCHAR2 |
16 |
CYBERSOURCE_CAPTURE_TIME |
Time associated with cybersource capture. |
VARCHAR2 |
6 |
CYBERSOURCE_DECISION |
Cybersource decision associated with the record. |
VARCHAR2 |
1 |
CYBERSOURCE_MERCHANT_ID |
Business identifier for the cybersource merchant. |
VARCHAR2 |
16 |
CYBERSOURCE_MERCHANT_REF |
Cybersource merchant ref associated with the record. |
VARCHAR2 |
60 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
4 |
DETAIL_CODE |
Code identifying detail. |
VARCHAR2 |
4 |
EFFECTIVE_DATE |
Date associated with effective. |
DATE |
|
EXPORT_STATUS |
Export status associated with the record. |
VARCHAR2 |
1 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
INFO_TYPE |
Info type associated with the record. |
VARCHAR2 |
4 |
IS_DEGREE_CANDIDATE |
Indicator identifying whether degree candidate (Y/N). |
VARCHAR2 |
1 |
IS_ELIGIBLE_REG |
Indicator identifying whether eligible reg (Y/N). |
VARCHAR2 |
1 |
IS_ENROLL_OK |
Indicator identifying whether enroll ok (Y/N). |
VARCHAR2 |
1 |
IS_FULLY_APPLIED |
Indicator identifying whether fully applied (Y/N). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PARK_PAYMENT_METHOD_KEY |
Surrogate key identifying the park payment method. |
VARCHAR2 |
1 |
PARK_PAYMENT_STATUS_KEY |
Surrogate key identifying the park payment status. |
VARCHAR2 |
1 |
PAYMENT_AMOUNT |
Payment amount associated with the record. |
NUMBER |
9,2 |
PAYMENT_BATCH |
Payment batch associated with the record. |
VARCHAR2 |
32 |
PAYMENT_BEGIN_DATE |
Date associated with payment begin. |
DATE |
|
PAYMENT_END_DATE |
Date associated with payment end. |
DATE |
|
PAYROLL_PERIOD |
Payroll period associated with the record. |
VARCHAR2 |
2 |
PAYROLL_YEAR |
Payroll year associated with the record. |
VARCHAR2 |
4 |
PAY_DATE |
Date associated with pay. |
DATE |
|
PERSONNEL_NUMBER |
Personnel number associated with the record. |
VARCHAR2 |
8 |
POSTING_DATE |
Date associated with posting. |
DATE |
|
PROCESSOR_RESPONSE_CD |
Processor response cd associated with the record. |
VARCHAR2 |
3 |
REQUEST_ID |
Business identifier for the request. |
VARCHAR2 |
22 |
SA_DESCRIPTION |
Description of sa. |
VARCHAR2 |
128 |
SA_ERROR |
Sa error associated with the record. |
VARCHAR2 |
1 |
SA_ERROR_MESSAGE |
Sa error message associated with the record. |
VARCHAR2 |
128 |
SA_FILENAME |
Sa filename associated with the record. |
VARCHAR2 |
128 |
SA_REVERSAL |
Sa reversal associated with the record. |
VARCHAR2 |
1 |
STUDENT_NAME |
Student name associated with the person. |
VARCHAR2 |
128 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
10 |
TRANSACTION_ID |
Business identifier for the transaction. |
VARCHAR2 |
16 |
TRANSACTION_NUMBER |
Transaction number associated with the record. |
VARCHAR2 |
8 |
UPDATED_AT |
Time associated with updated. |
VARCHAR2 |
6 |
UPDATED_BY |
Updated by associated with the record. |
VARCHAR2 |
12 |
UPDATED_ON |
Date associated with updated. |
DATE |
|
WAGE_TYPE |
Wage type associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |