W_CONTRACT_D
Data Mapping
Field | Description | Data Type |
|---|---|---|
CONTRACT_OBJECT_ID | Unique key | NUMBER(19) |
ADDRESS_1 | Address 1 from Organization Profile | VARCHAR2(150) |
ADDRESS_2 | Address 2 from Organization Profile | VARCHAR2(80) |
BILLED_TO_DATE | Total billed against subcontract | NUMBER(14,2) |
CITY | City from Organization Profile | VARCHAR2(60) |
CONTRACT_CREATION_DATE | The date the contract was created in TPM. | DATE |
CONTRACT_DATE | Contract date from Contact Maintenance | DATE |
CONTRACT_NUMBER | Contract number assigned | VARCHAR2(1000) |
COUNTY | County from Organization Profile | VARCHAR(50) |
DATE_UPDATED | DATE_UPDATED is the date that this record was updated in the TPM Data Service database. For more information, view the Managing Incremental Updates section in Help. | DATE |
LAST_DRAW_NUM | Last Initiated Draw on the Project the contract is associated with. | NUMBER |
GC_NAME | General Contractor name | VARCHAR2(2000) |
NET_CHANGE_ORDER_AMOUNT | Value of change order | NUMBER |
ORG_ID | Textura customer number | NUMBER(19) |
ORG_NAME | Organization name | VARCHAR2(2000) |
PARENT_CONTRACT_OBJECT_ID | Foreign Key | NUMBER(19) |
PERCENT_COMPLETE | Percent complete for subcontract | INTEGER |
PHONE1 | Phone 1 from Organization Profile | VARCHAR2(50) |
PHONE2 | Phone 2 from Organization Profile | VARCHAR2(50) |
PROJECT_CREATED | Date project created | DATE |
PROJECT_NAME | Project name | VARCHAR2(2000) |
PROJECT_NUMBER | Project number | VARCHAR2(2000) |
PROJECT_OBJECT_ID | Foreign key to W_T_PROJECT_D table | NUMBER(19) |
SUBDIVISIONCODE | Country and State from Organization Profile | VARCHAR2(6) |
TAXID | Tax ID from Organization Profile | VARCHAR2(60) |
TPA_ACCEPTANCE_DATE | Date TPA offer accepted by subcontractor | DATE |
TPA_DECLINED_DATE | Date TPA offer declined by user | DATE |
TPA_DECLINED_PHONE | Phone number of user who declined TPA offer | VARCHAR2(250) |
TPA_EMAIL | Email of user who is assigned as TPA contact | VARCHAR2(256) |
TPA_FEE_AT_DECLINE | TPA fee offered when declined by user | NUMBER(16, 2) |
TPA_FIRSTNAME | First name of user who is assigned as TPA contact | VARCHAR2(100) |
TPA_LAST_FUNDING_DATE | Last TPA funding against contract | DATE |
TPA_LASTNAME | Last name of user who is assigned as TPA contact | VARCHAR2(100) |
TPA_OFFER_CONTRACT | TPA terms offered on contract | NUMBER(16,2) |
TPA_PHONE | Phone Number of user who is assigned as TPA contact | VARCHAR2(50) |
TPA_PREVIOUS_ENROLLMENT | Boolean indication of previous enrollment in TPA | VARCHAR2(10) |
TPA_REASON_FOR_DECLINE | Reason for declining TPA offer | VARCHAR2(500) |
ZIPCODE | Zip Code from Organization Profile | VARCHAR2(30) |
TPA_STATUS | TPA status (Ineligible, Eligible, Enrolled, Disabled) | NVARCHAR2(15) |
TPA_TENOR | TPA maturity interval | NUMBER |
TPA_USER_WHO_DECLINED | First and last name of user who declined TPA offer | VARCHAR2(250) |
VENDOR_ID | Vendor ID assigned to Subcontractor | VARCHAR2(50) |
ZIPCODE | Zip Code from Organization Profile | VARCHAR2(30) |
Last Published Tuesday, February 6, 2024