PJB_STD_CLIN_INTER_ATTRS_INT
Interface table for importing contract line internal attributes in Fusion.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJB_STD_CLIN_INTER_ATTRS_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch Id is unique for a bulk import batch. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier for each interface row within a batch. | |
| EXT_SOURCE | VARCHAR2 | 150 | Along with Ext_Key, it forms a unique key in pjb_clin_internal_attributes table. | ||
| EXT_KEY | VARCHAR2 | 150 | Along with Ext_Source, it forms a unique key in pjb_clin_internal_attributes table. | ||
| LINE_PUID | VARCHAR2 | 120 | Unique identifier of the contract line for which internal attributes are created. | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Gives status of a row during import. Possible values are - I(In-process), V(Valid), S(Success), W(Warning), E(Error) and X(Format error). | ||
| ACTION_CODE | VARCHAR2 | 30 | Specifies operation for a row. Possible values are NULL, INSERT, UPDATE and DELETE. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | Internal column and will be set to UPDATE or INSERT for rows with ACTION_CODE=NULL depending on row already exists or not. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Internal column, used by file import to save the individual sys task id for each input csv file. | ||
| FILE_RECORD_NUM | NUMBER | 18 | Internal column, used by file import to save the record number in each input csv file. | ||
| LANGUAGE_CODE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable foreign key columns are translated. | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_clin_internal_attributes table for functional usage. | ||
| MAJOR_VERSION | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_clin_internal_attributes table for functional usage. | ||
| CONTRACT_ID | NUMBER | 18 | Not user enterable. For Internal usage. Refer to pjb_clin_internal_attributes table for functional usage. | ||
| PROVIDER_BUSINESS_UNIT_ID | NUMBER | 18 | Identifier of the provider business unit of the contract. | ||
| PROVIDER_BU_NAME | VARCHAR2 | 240 | Name of the provider business unit. | ||
| RECEIVER_PROJECT_ID | NUMBER | 18 | Identifier of the receiver project defined on contract line internal attributes. | ||
| RECEIVER_PROJECT_NUMBER | VARCHAR2 | 25 | Receiver project number defined on contract line internal attributes. | ||
| RECEIVER_TASK_ID | NUMBER | 18 | Identifier of the task defined on contract line internal attributes. | ||
| RECEIVER_TASK_NUMBER | VARCHAR2 | 100 | Receiver task number used in contract line internal attributes. | ||
| EXPENDITURE_ORG_ID | NUMBER | 18 | Identifier of the expenditure organization defined on contract line internal attributes. | ||
| EXPENDITURE_ORG_NAME | VARCHAR2 | 240 | Name of the expenditure organization used in contract line internal attributes. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type defined on contract line internal attributes. | ||
| EXPENDITURE_TYPE_NAME | VARCHAR2 | 240 | Name of the expenditure type used in contract line internal attributes. | ||
| INTERNAL_CLIN_ATTR_OVN | NUMBER | 9 | Object Version Number copied from corresponding clin internal attributes record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| RCVR_BUSINESS_UNIT_ID | NUMBER | 18 | Receiver business unit that belongs to the bill to contact LE of the bill plan. | ||
| RCVR_BU_NAME | VARCHAR2 | 240 | Receiver business unit name that belongs to the bill to contact LE of the bill plan. | ||
| RCVR_SETUP_CODE | VARCHAR2 | 30 | Internal column that indicates if the receiver setup is for one project or all projects of a receiver business unit. | ||
| EXP_TYPE_ORIG_EI_FLAG | VARCHAR2 | 1 | If the flag is 'Y', set the Expenditure Type on the internal AP invoice line to the Expenditure Type on the original provider expenditure item. | ||
| EXP_ORG_SOURCE | VARCHAR2 | 20 | Optional Y/N flag. If the flag is 'Y', set Expenditure Org on the IC AP invoice line to Task-owning Org of the expenditure item. | ||
| CTRL_MS_DATES_FLAG | VARCHAR2 | 1 | Indicates whether milestone date changes are allowed in the project plan. Possible values are Y and N. Setting it to Y indicates that the milestone dates can be modified in the project plan. | ||
| MANAGE_MS_IN_PLAN_FLAG | VARCHAR2 | 1 | Indicates whether milestones are managed in the project plan. Possible values are Y and N. Setting it to Y specifies that milestones are managed in the project plan. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_STD_CLIN_ATTRS_INT_U1 | Unique | FUSION_TS_INTERFACE | BATCH_ID, INTERFACE_ROW_ID |
| PJB_STD_CLIN_INTER_INT_N1 | Non Unique | FUSION_TS_INTERFACE | BATCH_ID, IMPORT_STATUS_CODE, EXT_KEY, EXT_SOURCE |
| PJB_STD_CLIN_INTER_INT_N2 | Non Unique | FUSION_TS_INTERFACE | BATCH_ID, RCVR_SETUP_CODE |