W_T_PROJECT_D
Data Mapping
Field | Description | Data Type |
---|---|---|
PROJECT_OBJECT_ID | Unique key | NUMBER(19) |
ACTIVE | Project status (Active, Inactive) | VARCHAR2(50) |
ACTUAL_START | Project start date from Project Settings | DATE |
ADDRESS_1 | Address line 1 from Site Information
| VARCHAR2(50) |
ADDRESS_2 | Address line 2 from Site Information | VARCHAR2(50) |
ARCHITECT_NAME | Name of architect assigned to project | VARCHAR2(2000) |
CITY | City from Site Information | VARCHAR2(255) |
CONSTRUCTION_TYPE | Project Type (Residential - New, Residential - Remodel, Commercial - New, Commercial - Remodel) | VARCHAR2(1000) |
COUNTRY_NAME | Country from Site Address | VARCHAR2(255) |
COUNTY | County from Site Address | VARCHAR2(255) |
CURRENCY_LABEL | Currency assigned to project | VARCHAR2(10) |
DATE_CREATED | Date project created | DATE |
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 |
DISBURSING_ORG_NAME | Name of organization disbursing payments | VARCHAR2(2000) |
ESTIMATED_COMPLETION | Estimated completion date | DATE |
ESTIMATED_START | Estimated start date | DATE |
EXCLUDE_FROM_EXPORT | Exclude this project from invoice and payment exports selected on Project Settings | VARCHAR2(10) |
GC_FUNDING_ORG_NAME | General Contractor Funding Organization from Project Participants | NVARCHAR2(1000) |
GC_NAME | General contractor name | VARCHAR2(2000) |
INVOICE_NUMBER_FORMAT | System Generated Invoice Number Format selected on Project Settings | VARCHAR2(200) |
LAST_DRAW_PERIOD_TO_DATE | Last draw period to date on the project | DATE |
ORACLE_GC_PART_DESCRIPTION | Project Fee Description | VARCHAR(50 CHAR) |
ORACLE_GC_PART_NUMBER | Project Fee Number | NUMBER |
ORIGINAL_COMPLETION | Original completion date | DATE |
OWNER_NAME | Project owner assigned to project | VARCHAR2(2000) |
PROGRAM_ID | TPA Program identifier | NUMBER(19) |
PROJECT_NAME | Name of project | VARCHAR2(200) |
PROJECT_NUMBER | GC project number | VARCHAR2(1000) |
PROPERTY_NAME | Site name from Site Information | VARCHAR2(2000) |
PROPERTY_OWNER | Property owner from Site Information | VARCHAR2(2000) |
SEGMENT_DESCRIPTION | Description of segment ID | VARCHAR2(2000) |
SEGMENT_NAME | Segment ID assigned to project | VARCHAR2(255) |
STATEPROVINCE | State project is located | VARCHAR2(255) |
SUB_FUNDING_ORG_NAME | Subcontractor funding organization from Project Participants | VARCHAR2(1000 CHAR) |
TPA_AUTO_ENROLL | Project setting set to enable TPA eligibility for all contracts (True/False) | NVARCHAR2(10) |
TPA_FUNDER_NAME | Name of funding account on TPA program assigned to project | VARCHAR2(1000) |
TPA_MATURITY_INTERVAL | TPA invoice maturity interval assigned to project | NUMBER (38,0) |
TPA_PROGRAM_NAME | Name of TPA program assigned to project | NVARCHAR2(200) |
TPA_TERM_CODE | Name of assigned project pricing structure | NVARCHAR2(1000) |
ZIPCODE | Zipcode from Site Information | VARCHAR2(255) |
Last Published Tuesday, February 6, 2024