PJC_LD_INTERFACE_RUN_GT
This global temporary table contains the interface and run data.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJC_LD_INTERFACE_RUN_GT_PK |
LD_INTERFACE_RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LD_INTERFACE_RUN_ID | NUMBER | 18 | Yes | Primary key of the table. | |
| LD_INTERFACE_ID | NUMBER | 18 | Interface Identifier. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the request to process the imported data. | ||
| BATCH_NAME | VARCHAR2 | 200 | Name of the payroll batch imported from the payroll system. | ||
| PERIOD_START_DATE | DATE | Start date of the payroll period for the person. | |||
| PERIOD_END_DATE | DATE | End date of the payroll period for the person. | |||
| PERSON_ID | NUMBER | 18 | Person ID of the human resources person related to this cost record. | ||
| PERSON_NUMBER | VARCHAR2 | 30 | Number of the person whose labor cost is being imported from payroll system. | ||
| PERSON_NAME | VARCHAR2 | 240 | Name of the person whose labor cost is being imported from payroll system. | ||
| PERSON_EMAIL | VARCHAR2 | 240 | Email of the person whose labor cost is being imported from payroll system. | ||
| ASSIGNMENT_ID | NUMBER | 18 | Assignment ID of the human resources assignment related to this cost record. | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | 50 | Number of the human resources assignment for the person. | ||
| ASSIGNMENT_NAME | VARCHAR2 | 80 | Name of the human resources assignment for the person. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code. | ||
| PAY_AMOUNT | NUMBER | Pay amount for the person and assignment for the given element, payroll period start and end date. | |||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Unique identifier of this record in the payroll system. | ||
| PROCESSED_STATUS_CODE | VARCHAR2 | 30 | Status of the record. | ||
| ORDER_NUMBER | NUMBER | Order number of an interface id. | |||
| PROCESSED_MESSAGE | VARCHAR2 | 4000 | Name of the message, error or warning for the record. | ||
| MESSAGE_CODE | VARCHAR2 | 200 | Message Code. | ||
| MESSAGE_USER_DETAILS | VARCHAR2 | 4000 | Message Details. | ||
| MESSAGE_USER_ACTION | VARCHAR2 | 4000 | Message User Actions. | ||
| DRAFT_REQUEST_ID | NUMBER | 18 | Request ID for the Labor Distribution run. | ||
| BC_PASS_FLAG | VARCHAR2 | 1 | Budget Check Result Indicator. | ||
| ADJUSTMENT_FLAG | VARCHAR2 | 1 | Adjustment Process Indicator. | ||
| PRIOR_INTERFACE_ID | NUMBER | 18 | Prior Distribution Interface ID. | ||
| RULE_ID | NUMBER | 18 | Allocation rule identification number. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| START_DATE_ACTIVE | DATE | The date when the rule becomes effective. | |||
| END_DATE_ACTIVE | DATE | The date when the rule becomes ineffective. | |||
| LD_DAILY_RATE | NUMBER | Person assignment daily rate. | |||
| REVERSE_REQUEST_ID | NUMBER | 18 | Reversal request ID. | ||
| POOL_AMOUNT | NUMBER | Labor Distribution pool amount for the period. | |||
| PROCESSING_START_DATE | DATE | Processing start date. | |||
| PROCESSING_END_DATE | DATE | Processing end date. | |||
| REVERSAL_DATE | DATE | Reversal date. | |||
| ELEMENT_TYPE | VARCHAR2 | 80 | Name of the pay element for the person. | ||
| WORKING_DAYS | NUMBER | Number of working days between processing start date and processing end date. | |||
| ELEMENT_TYPE_ID | NUMBER | 18 | Pay Element Type ID. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PJC_LD_INTERFACE_RUN_GT_N1 | Non Unique | LD_INTERFACE_ID, ORDER_NUMBER |
| PJC_LD_INTERFACE_RUN_GT_U1 | Unique | LD_INTERFACE_RUN_ID |