PJF_SYSTEM_LINKAGES
PA_SYSTEM_LINKAGES stores system-defined categories used to determine how items should be processed. Examples of system linkages (Expenditure Type Classes) are: Expense Report, Usages, and Straight Time. Oracle Projects provides all system linkages upon installation. The relationships between Expenditure Types and System Linkages are stored in PA_EXPEND_TYP_SYS_LINKS.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_SYSTEM_LINKAGES_PK |
FUNCTION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FUNCTION | VARCHAR2 | 30 | Yes | The code name of the system linkage that drives processing | |
| APPLICATION_ID | NUMBER | 18 | Yes | The identifier of the Oracle application that is integrated in the processing of Oracle Projects | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| MEANING | VARCHAR2 | 80 | Yes | The short, user-friendly name of the system linkage | |
| DESCRIPTION | VARCHAR2 | 80 | Description of the system linkage | ||
| PROJECT_MANUFACTURING_FLAG | VARCHAR2 | 1 | Yes | Flag to identify if system linkage is related to project manufacturing | |
| LABOR_NON_LABOR_FLAG | VARCHAR2 | 1 | Yes | Flag to identify if system linkage is labor related | |
| COST_DEBIT_FUNCTION_CODE | VARCHAR2 | 15 | Yes | System-defined code that uniquely identifies the Auto Accounting function for the cost distribution process | |
| COST_CREDIT_FUNCTION_CODE | VARCHAR2 | 15 | Yes | System-defined code that uniquely identifies the Auto Accounting function for the cost transfer process | |
| COST_JE_CATEGORY_NAME | VARCHAR2 | 25 | Journal entry category | ||
| CC_FUNCTION_TRANSACTION_CODE | VARCHAR2 | 30 | Function transaction code for Cross Charge transactions | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_SYSTEM_LINKAGES | pjf_system_linkages | COST_CREDIT_FUNCTION_CODE |
| pjc_commitment_txns | pjf_system_linkages | SYSTEM_LINKAGE_FUNCTION |
| pjc_exp_items_all | pjf_system_linkages | SYSTEM_LINKAGE_FUNCTION |
| pjf_expend_typ_sys_links | pjf_system_linkages | SYSTEM_LINKAGE_FUNCTION |
| pjf_system_linkages | pjf_system_linkages | COST_CREDIT_FUNCTION_CODE |
| pjc_alloc_rules_all | pjf_system_linkages | TARGET_EXP_TYPE_CLASS |
| pjc_alloc_rules_all | pjf_system_linkages | OFFSET_EXP_TYPE_CLASS |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_SYSTEM_LINKAGES_U1 | Unique | Default | FUNCTION, APPLICATION_ID |
| PJF_SYSTEM_LINKAGES_U2 | Unique | Default | APPLICATION_ID, MEANING |
| PJF_SYSTEM_LINKAGES_U3 | Unique | Default | FUNCTION |