PJS_PROG_PROJ_EXTR_STATUS
Table to store program projects denormalized data. UPPD will maintain this table.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJS_PROG_PROJ_EXTR_STATUS_PK |
OBJECT_ID, OBJECT_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_ID | NUMBER | 18 | Yes | Unique Identifier of the object. | |
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | Classifies type of the object. For example Project. | |
| EXTRACTION_STATUS | VARCHAR2 | 30 | Extraction status of the object. | ||
| EXTRACTION_STATUS_PLAN | VARCHAR2 | 30 | Extraction status of the plan data. | ||
| EXTRACTION_STATUS_COST | VARCHAR2 | 30 | Extraction status of the cost data. | ||
| EXTRACTION_STATUS_CMT | VARCHAR2 | 30 | Extraction status of the commitments data. | ||
| EXTRACTION_STATUS_REV | VARCHAR2 | 30 | Extraction status of the revenue data. | ||
| EXTRACTION_STATUS_INV | VARCHAR2 | 30 | Extraction status of the invoice data. | ||
| EXTRACTION_STATUS_SCH | VARCHAR2 | 30 | Extraction status of the scheduling data. | ||
| LAST_SUM_PLAN_DATE | DATE | Last summarization date for the plan data. | |||
| LAST_AVAILABLE_PLAN_DATE | DATE | Last available date of the plan data. | |||
| LAST_SUM_COST_DATE | DATE | Last summarization date for the cost data. | |||
| LAST_AVAILABLE_COST_DATE | DATE | Last available date of the cost data. | |||
| LAST_SUM_CMT_DATE | DATE | Last summarization date for the commitment data. | |||
| LAST_AVAILABLE_CMT_DATE | DATE | Last available date of the commitment data. | |||
| LAST_SUM_REV_DATE | DATE | Last summarization date for the revenue data. | |||
| LAST_AVAILABLE_REV_DATE | DATE | Last available date of the revenue data. | |||
| LAST_SUM_INV_DATE | DATE | Last summarization date for the invoice data. | |||
| LAST_AVAILABLE_INV_DATE | DATE | Last available date of the invoice data. | |||
| LAST_SUM_SCH_DATE | DATE | Last available date for the scheduling data. | |||
| LAST_AVAILABLE_SCH_DATE | DATE | Last summarization date for the scheduling data. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| PROJECT_UNIT_ID | NUMBER | 18 | Indicates the identifier of the project unit associated to the row. | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Code identifying the project ledger currency. | ||
| LEDGER_ID | NUMBER | 18 | Indicates the identifier of the ledger associated to the row. | ||
| GL_CALENDAR_ID | NUMBER | 18 | Indicates the identifier of the accounting calendar asscociated to the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ADDL_ATTRIBUTE1 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE2 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE3 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE4 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| ADDL_ATTRIBUTE5 | VARCHAR2 | 150 | Column supporting alphanumeric characters reserved for internal use. | ||
| START_DATE | DATE | Start date of the object associated to the row. | |||
| FINISH_DATE | DATE | Finish date of the object associated to the row. | |||
| GL_PERIOD_SET_NAME | VARCHAR2 | 15 | Name of the accounting calendar. | ||
| GL_PERIOD_TYPE | VARCHAR2 | 15 | Accounting period type such as, weekly, monthly, quarterly, and so on. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PROG_PROJ_EXTR_STATUS_U1 | Unique | Default | OBJECT_ID, OBJECT_TYPE |