DW_EMPLOYEE_EXPENSE_CF

Employee Expense Fact

Details

Module: Expenses

Key Columns

EXPENSE_DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENSE_DIST_ID NUMBER 38 0 True Unique identifier of the expense distribution of a specific expense item.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier. Value is derived from expense distribution id    
EXPENSE_AMOUNT NUMBER       Amount to be reimbursed to the individual against this expense distribution.    
LEDGER_EXPENSE_AMOUNT NUMBER       Ledger amount calculated at distribution grain    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion from ledger currency    
GLOBAL_EXPENSE_AMOUNT NUMBER       Ledger amount in global currency.    
RECEIPT_AMOUNT NUMBER       Receipt amount calculated at distribution grain    
ORIG_REIMBURSABLE_AMOUNT NUMBER       Original reimburable amount calculated at distribution grain    
COST_CENTER VARCHAR2 128     Cost center that the expense needs to be charged to    
PJC_PROJECT_ID NUMBER 38 0   Identifier of the project used to build the transaction    
PJC_TASK_ID NUMBER 38 0   Identifier of the task used to build the transaction    
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0   Expenditure type used to build the transaction    
PJC_ORGANIZATION_ID NUMBER 38 0   Expenditure type used to build the transaction    
PJC_EXPENDITURE_ITEM_DATE DATE       Date on which a project-related expense is incurred.    
CODE_COMBINATION_ID NUMBER 38 0   Identifier of the accounting code combination that expense is charged to.    
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
EXPENSE_ID NUMBER 38 0   Unique identifier of a specific expense item.    
EXPENSE_TEMPLATE_ID NUMBER 38 0   Unique identifier of a specific expense template. DW_EXM_EXPENSE_TEMPLATES_D EXPENSE_TEMPLATE_ID
EXPENSE_TYPE_ID NUMBER 38 0   Unique identifier for a specific expense type. DW_EXM_EXPENSE_TYPES_D EXPENSE_TYPE_ID
EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 128     This grouping allows expense types to include information such as class of fare, merchant, ticket number    
EXPENSE_CATEGORY_CODE VARCHAR2 128     Classification of an expense item such as business or personal.    
EXPENSE_SOURCE VARCHAR2 128     Source of an expense item, such as cash or corporate card.    
EXPENSE_ITEM_DESCRIPTION VARCHAR2 256     Description of an expense item.    
LINE_EXPENSE_AMOUNT NUMBER       Amount to be reimbursed to the individual in reimbursable currency for this expense.    
LINE_ORIG_REIMBURSABLE_AMOUNT NUMBER       Original amount to be reimbursed to the individual for this expense.    
EXCHANGE_RATE NUMBER       Rate that represents the amount one currency can be exchanged for another at a specific point in time.    
ORIG_EXCHANGE_RATE NUMBER       Exchange rate of the expense before it was changed.    
RECEIPT_CURRENCY_CODE VARCHAR2 64     Receipt currency of an expense item.    
LINE_RECEIPT_AMOUNT NUMBER       Amount of the receipt in the receipt currency.    
LINE_PERSONAL_RECEIPT_AMOUNT NUMBER       Amount of the expense that is marked as personal.    
RECEIPT_REQUIRED_FLAG VARCHAR2 16     Indicator of whether this expense requires a receipt.    
RECEIPT_MISSING_FLAG VARCHAR2 16     Indicator of whether the receipts are missing for this expense.    
TRAVEL_TYPE VARCHAR2 128     Type of flight, whether domestic or international.    
AUDIT_ADJUSTMENT_REASON_CODE VARCHAR2 128     Reason code for reimbursable amount to the individual during audit.    
AUDIT_ADJUSTMENT_REASON VARCHAR2 256     Reason for adjusting the reimbursable amount to the individual during audit.    
POLICY_VIOLATED_FLAG VARCHAR2 16     Indicator of whether the expense violated company policies.    
POLICY_SHORTPAY_FLAG VARCHAR2 16     Indicator of whether the expense is short paid due to policy noncompliance.    
JUSTIFICATION VARCHAR2 256     Reason an expense was incurred.    
JUSTIFICATION_REQUIRED_FLAG VARCHAR2 16     Indicator of whether the expense requires justification.    
TRANSACTION_DATE DATE       Date when the expense occurred or the first day of an expense that spans multiple days.    
END_DATE DATE       Last day of an expense that spans multiple days.    
LOCATION VARCHAR2 512     Location where the expense was incurred.    
MERCHANT_NAME VARCHAR2 512     Name of the merchant where the expense was incurred.    
IMG_RECEIPT_REQUIRED_FLAG VARCHAR2 16     Indicator of whether this expense requires an imaged receipt.    
EXPENSE_CREATION_METHOD_CODE VARCHAR2 32     Method of expense item creation, such as mobile iOS device or mobile Android device.    
LEGAL_EMPLOYER_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
EXPENSE_REPORT_ID NUMBER 38 0   Identifier of the expense report.    
EXPENSE_REPORT_NAME VARCHAR2 256     Report Name    
PERSON_ID NUMBER 38 0   Identifier of the person whose expenses are included in this expense report. DW_PERSON_D PERSON_ID
PREPARER_ID NUMBER 38 0   Identifier of the person who created the expense report. DW_PERSON_D PERSON_ID
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0   Ledger identifier. DW_LEDGER_D LEDGER_ID
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
LEDGER_LINE_EXPENSE_AMOUNT NUMBER       Functional currency amount at expense line    
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ASSIGNMENT_ID NUMBER 38 0   Identifier of the assignment of the person on the expense report. DW_WRKFRC_ASG_F ASSIGNMENT_ID
PURPOSE VARCHAR2 256     Business activities that justify the expense report.    
REPORT_CREATION_METHOD_CODE VARCHAR2 32     Method of expense report creation, such as mobile iOS device or mobile Android device.    
EXPENSE_STATUS_CODE VARCHAR2 128     Expense report approval status, such as Approved, Pending Manager Approval, or Paid.    
RECEIPTS_STATUS_CODE VARCHAR2 128     Receipt status of an expense report, such as Missing, Required, and Received.    
SHORTPAY_TYPE_CODE VARCHAR2 128     Indicator of why the expense report is short paid.    
BOTHPAY_FLAG VARCHAR2 16     Indicator whether report contains corporate card transactions with Both Pay payment liability.    
EXPENSE_REPORT_DATE DATE       Month, day, and year in which an expense report is saved or submitted.    
REPORT_SUBMIT_DATE DATE       Month, day, and year in which an expense report is submitted.    
RECEIPTS_RECEIVED_DATE DATE       Date when receipts for the expense report are received.    
EXPENSE_STATUS_DATE DATE       Date when expense report acquired the current status.    
REPORT_EXPENSE_AMOUNT NUMBER       Total amount of the expense report in reimbursement currency.    
REIMBURSEMENT_CURRENCY_CODE VARCHAR2 64     Currency of the amount to be reimbursed to the individual for the expenses incurred.    
AUDIT_CODE VARCHAR2 128     Audit type for the expense report based on receipt requirements.    
FINAL_APPROVAL_DATE DATE       Date when final approval is obtained for the report    
PAYMENT_METHOD_CODE VARCHAR2 128     Method of payment for this expense report such as check, cash, or credit.    
CASH_EXPENSE_PAID_DATE DATE       Date when cash expense was reimbursed to the individual.    
JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
DEPARTMENT_ID NUMBER 38 0   Department Identifier#5 DW_DEPARTMENT_D DEPARTMENT_ID
LEGISLATION_CODE VARCHAR2 256     Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
CREATION_DATE DATE       Date of the creation of the row. This is a date converted column.    
IMAGED_RECEIPTS_RECEIVED_DATE DATE       Date when an imaged receipt is received for an expense report.    
EXM_EXPENSE_DISTS_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    

Copyright © 2019, 2023, Oracle and/or its affiliates.