GL_XFR_PSFT_STATUS_GT
GL_XFR_PSFT_STATUS_GT is a temporary table used by the Peoplesoft Transform and Import program to record interim data. For each Peoplesoft business unit and ledger combination, it stores the associated fusion ledger name and id, the associated chart of accounts mapping name, id, and to chart of accounts, the status of the run, the number of journals and lines processed, the default values to be used for each segment, and the group id and request id used by Journal Import.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
GL_XFR_PSFT_STATUS_GT_PK |
PEOPLESOFT_BUSINESS_UNIT_NAME, PEOPLESOFT_LEDGER_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PEOPLESOFT_BUSINESS_UNIT_NAME | VARCHAR2 | 5 | Yes | Peoplesoft business unit name | |
| PEOPLESOFT_LEDGER_NAME | VARCHAR2 | 10 | Yes | Peoplesoft ledger id | |
| FUSION_LEDGER_NAME | VARCHAR2 | 30 | Yes | Fusion ledger name | |
| FUSION_LEDGER_ID | NUMBER | 18 | Fusion ledger id | ||
| COA_MAPPING_NAME | VARCHAR2 | 33 | Chart of accounts mapping name | ||
| COA_MAPPING_ID | NUMBER | 18 | Chart of accounts mapping id | ||
| COA_MAP_TO_COA_NAME | VARCHAR2 | 60 | To chart of accounts of the chart of accounts mapping | ||
| STATUS_CODE | VARCHAR2 | 30 | Run status | ||
| JOURNAL_COUNT | NUMBER | 18 | Number of Peoplesoft journals processed by run | ||
| LINE_COUNT | NUMBER | 18 | Number of Peoplesoft lines processed by run | ||
| CHECK_PERIOD_FLAG | VARCHAR2 | 1 | Does period information need to be validated | ||
| GROUP_ID | NUMBER | 18 | Journal import group id | ||
| JOURNAL_IMPORT_REQUEST_ID | NUMBER | 18 | Journal import request id | ||
| SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_XFR_PSFT_STATUS_GT_U1 | Unique | PEOPLESOFT_BUSINESS_UNIT_NAME, PEOPLESOFT_LEDGER_NAME |