Scribd Logo
Upload

Welcome to Scribd!

  • 58 views

    Budgeting 89

    Uploaded by

    Sree Kapara
    This document describes database tables used for asset budgeting, cash management, and general ledger functions in a financial system. It includes tables for asset master data, depreciation schedules, budget checkouts, ledger postings, and other accounting and budgeting records. Primary keys, foreign keys and column definitions are provided for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Budgeting 89

    Uploaded by

    Sree Kapara
    58 views8 pages
    This document describes database tables used for asset budgeting, cash management, and general ledger functions in a financial system. It includes tables for asset master data, depreciation schedules, budget checkouts, ledger postings, and other accounting and budgeting records. Primary keys, foreign keys and column definitions are provided for each table.

    Original Description:

    Peoplesoft budgeting model

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes database tables used for asset budgeting, cash management, and general ledger functions in a financial system. It includes tables for asset master data, depreciation schedules, budget checkouts, ledger postings, and other accounting and budgeting records. Primary keys, foreign keys and column definitions are provided for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    58 views8 pages

    Budgeting 89

    Uploaded by

    Sree Kapara
    This document describes database tables used for asset budgeting, cash management, and general ledger functions in a financial system. It includes tables for asset master data, depreciation schedules, budget checkouts, ledger postings, and other accounting and budgeting records. Primary keys, foreign keys and column definitions are provided for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 8

    ASSET BUDGETING -- Physical / <Main Subject Area>

    PS_BP_ASSET_OPTION SETID: CHAR(5) NOT NULL PS_BP_DEPR_ACCOUNT SETID: CHAR(5) NOT NULL (FK) ACCOUNT: CHAR(10) NOT NULL BP_ASSET_PREFIX: CHAR(5) NOT NULL BP_ASSET_NBR_LAST: DECIMAL(12) NOT NULL BP_CASH_ACCOUNT: CHAR(10) NOT NULL BP_CASH_ACCT_OVER: CHAR(1) NOT NULL BP_ASSET_ACCOUNT: CHAR(10) NOT NULL BP_ASSET_ACCT_OVER: CHAR(1) NOT NULL BP_DEPR_ACCOUNT: CHAR(10) NOT NULL BP_DEPR_ACCT_OVER: CHAR(1) NOT NULL CAP_NUM: CHAR(15) NOT NULL CAP_SEQUENCE: SMALLINT NOT NULL BP_CAP_EXTRACT_OPT: CHAR(1) NOT NULL BP_CAP_OVER: CHAR(1) NOT NULL BP_CAP_REQUIRED: CHAR(1) NOT NULL BP_OVER_LIFE: CHAR(1) NOT NULL BP_OVER_METHOD: CHAR(1) NOT NULL BP_OVER_SALVAGE: CHAR(1) NOT NULL

    PS_BP_ASSET_ACCT SETID: CHAR(5) NOT NULL (FK) ACCOUNT: CHAR(10) NOT NULL BP_ASSET_CASH: CHAR(1) NOT NULL

    PS_BP_CASH_ACCOUNT SETID: CHAR(5) NOT NULL (FK) ACCOUNT: CHAR(10) NOT NULL

    PS_BP_ASSET_ITEMS SETID: CHAR(5) NOT NULL PROFILE_ID: CHAR(10) NOT NULL EFFDT: PSDATE NOT NULL EFF_STATUS: CHAR(1) NOT NULL ASSET_CLASS: CHAR(10) NOT NULL DESCR: CHAR(30) NOT NULL COST: DECIMAL(26,3) NOT NULL METHOD: CHAR(2) NOT NULL ACCOUNT: CHAR(10) NOT NULL SALVAGE_VALUE: DECIMAL(26,3) NOT NULL LIFE: SMALLINT NOT NULL BP_CASH_ACCOUNT: CHAR(10) NOT NULL BP_ASSET_ACCOUNT: CHAR(10) NOT NULL BP_DEPR_ACCOUNT: CHAR(10) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL

    PS_BP_ASSET BP_CHECKOUTID: CHAR(33) NOT NULL (FK) MSSCONCATCOL: CHAR(256) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL BOOK: CHAR(10) NOT NULL ASSET_ID: CHAR(12) NOT NULL ACCOUNT: CHAR(10) NOT NULL ALTACCT: CHAR(10) NOT NULL SCENARIO: CHAR(10) NOT NULL PROJECT_ID: CHAR(15) NOT NULL BUDGET_PERIOD: CHAR(8) NOT NULL OPERATING_UNIT: CHAR(8) NOT NULL DEPTID: CHAR(10) NOT NULL PRODUCT: CHAR(6) NOT NULL FUND_CODE: CHAR(5) NOT NULL PROGRAM_CODE: CHAR(5) NOT NULL CLASS_FLD: CHAR(5) NOT NULL BUDGET_REF: CHAR(8) NOT NULL AFFILIATE: CHAR(5) NOT NULL AFFILIATE_INTRA1: CHAR(10) NOT NULL AFFILIATE_INTRA2: CHAR(10) NOT NULL CHARTFIELD1: CHAR(10) NOT NULL CHARTFIELD2: CHAR(10) NOT NULL CHARTFIELD3: CHAR(10) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL STATISTICS_CODE: CHAR(3) NOT NULL BP_CASH_ACCOUNT: CHAR(10) NOT NULL BP_ASSET_ACCOUNT: CHAR(10) NOT NULL BP_DEPR_ACCOUNT: CHAR(10) NOT NULL DESCR: CHAR(30) NOT NULL 1 ASSET_STATUS: CHAR(1) NOT NULL ACQUISITION_FY: SMALLINT NOT NULL ACQUISITION_AP: SMALLINT NOT NULL IN_SERVICE_FY: SMALLINT NOT NULL IN_SERVICE_AP: SMALLINT NOT NULL COST: DECIMAL(26,3) NOT NULL QUANTITY: DECIMAL(15,4) NOT NULL ASSET_CLASS: CHAR(10) NOT NULL PROFILE_ID: CHAR(10) NOT NULL METHOD: CHAR(2) NOT NULL SALVAGE_VALUE: DECIMAL(26,3) NOT NULL DISPOSAL_CODE: CHAR(1) NOT NULL PROCEEDS: DECIMAL(26,3) NOT NULL REMOVAL_COST: DECIMAL(26,3) NOT NULL LIFE: SMALLINT NOT NULL RETIREMENT_FY: SMALLINT NOT NULL RETIREMENT_AP: SMALLINT NOT NULL SPREADTYPE: SMALLINT NOT NULL SPREAD_TEMPLATE: CHAR(30) NOT NULL CAP_NUM: CHAR(15) NOT NULL CAP_SEQUENCE: SMALLINT NOT NULL BD_UPDATE_FLAG: CHAR(1) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL BP_BUDG_CNTR_ADV: CHAR(30) NOT NULL BP_EXCLUDE: CHAR(1) NOT NULL

    PS_BP_ASSET_DEPR BP_CHECKOUTID: CHAR(33) NOT NULL (FK) MSSCONCATCOL: CHAR(256) NOT NULL (FK) BUSINESS_UNIT: CHAR(5) NOT NULL BOOK: CHAR(10) NOT NULL ASSET_ID: CHAR(12) NOT NULL ACCOUNT: CHAR(10) NOT NULL ALTACCT: CHAR(10) NOT NULL PROJECT_ID: CHAR(15) NOT NULL SCENARIO: CHAR(10) NOT NULL FISCAL_YEAR: SMALLINT NOT NULL ACCOUNTING_PERIOD: SMALLINT NOT NULL DEPR: DECIMAL(26,3) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL BUDGET_PERIOD: CHAR(8) NOT NULL OPERATING_UNIT: CHAR(8) NOT NULL DEPTID: CHAR(10) NOT NULL PRODUCT: CHAR(6) NOT NULL FUND_CODE: CHAR(5) NOT NULL PROGRAM_CODE: CHAR(5) NOT NULL CLASS_FLD: CHAR(5) NOT NULL BUDGET_REF: CHAR(8) NOT NULL AFFILIATE: CHAR(5) NOT NULL AFFILIATE_INTRA1: CHAR(10) NOT NULL AFFILIATE_INTRA2: CHAR(10) NOT NULL CHARTFIELD1: CHAR(10) NOT NULL CHARTFIELD2: CHAR(10) NOT NULL CHARTFIELD3: CHAR(10) NOT NULL NET_BK_VALUE: DECIMAL(26,3) NOT NULL STATISTICS_CODE: CHAR(3) NOT NULL BD_UPDATE_FLAG: CHAR(1) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_BUDG_CNTR_ADV: CHAR(30) NOT NULL

    PS_BP_ADV_CHECKOUT BP_CHECKOUTID: CHAR(33) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL BP_PLANNING_ID: CHAR(15) NOT NULL BUDGET_PHASE_ID: CHAR(30) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_BUDGET_VER_ID: CHAR(1) NOT NULL BP_ADV_ROLENAME: CHAR(80) NOT NULL SCENARIO: CHAR(10) NOT NULL OPRID: CHAR(30) NOT NULL TRANSACTION_ID: CHAR(10) NOT NULL READ_ONLY_FLAG: CHAR(1) NOT NULL BP_CHECKOUT_DT: PSDATETIME NULL TYPE: CHAR(1) NOT NULL BAM_MODEL_ID: CHAR(20) NOT NULL

    1, 1 / 1, 1 -- 1:24:30 PM , 9/3/2004

    BAM SETUP -- Physical / <Main Subject Area>

    PS_BP_ADV_XFER_PAR TRANSACTION_ID: CHAR(10) NOT NULL (FK) ROW_NUM: SMALLINT NOT NULL (FK) PARM_SEQ: SMALLINT NOT NULL STRING_FLAG: CHAR(1) NOT NULL FIELDNAME: CHAR(18) NOT NULL BP_ADV_MEMBER: CHAR(30) NOT NULL BP_ADV_MEMBER_TYPE: CHAR(1) NOT NULL

    PS_BP_INQ_FILTER BP_CHECKOUTID: CHAR(33) NOT NULL BP_INIT_BUD_CENTER: CHAR(15) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_TARGET_CURR: CHAR(3) NOT NULL BP_INQ_CCY_OPTION: CHAR(1) NOT NULL BP_INQ_DISP_OPT: CHAR(1) NOT NULL

    PS_BP_ADV_XFER_LN TRANSACTION_ID: CHAR(10) NOT NULL (FK) ROW_NUM: SMALLINT NOT NULL RECNAME: CHAR(15) NOT NULL BP_ADV_TABLE_NAME: CHAR(100) NOT NULL MAP_ACTION: CHAR(1) NOT NULL SQLID: CHAR(30) NOT NULL FIELDNAME: CHAR(18) NOT NULL

    PS_BP_INQ_CF_FILTR BP_CHECKOUTID: CHAR(33) NOT NULL BP_INIT_BUD_CENTER: CHAR(15) NOT NULL PF_PART_ID: CHAR(20) NOT NULL VALUE_FIELD: CHAR(30) NOT NULL

    PS_BP_ADV_XFER TRANSACTION_ID: CHAR(10) NOT NULL DESCR: CHAR(30) NOT NULL

    PS_BP_ANAL_PARTS BP_BAM_INQUIRY_TYP: CHAR(1) NOT NULL CHARTFIELD: CHAR(18) NOT NULL CHARTFIELD_2: CHAR(18) NOT NULL PF_PART_ID: CHAR(20) NOT NULL TRANSACTION_ID: CHAR(10) NOT NULL

    PS_BP_ADV_CHECKOUT BP_CHECKOUTID: CHAR(33) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL BP_PLANNING_ID: CHAR(15) NOT NULL BUDGET_PHASE_ID: CHAR(30) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_BUDGET_VER_ID: CHAR(1) NOT NULL BP_ADV_ROLENAME: CHAR(80) NOT NULL SCENARIO: CHAR(10) NOT NULL OPRID: CHAR(30) NOT NULL TRANSACTION_ID: CHAR(10) NOT NULL READ_ONLY_FLAG: CHAR(1) NOT NULL BP_CHECKOUT_DT: PSDATETIME NULL TYPE: CHAR(1) NOT NULL BAM_MODEL_ID: CHAR(20) NOT NULL

    1, 1 / 1, 1 -- 1:23:43 PM , 9/3/2004

    BATCH PROCESSING -- Physical / <Main Subject Area>


    PS_BUS_UNIT_TBL_GL BUSINESS_UNIT: CHAR(5) AS_OF_DATE: PSDATE BASE_CURRENCY: CHAR(3) BUSINESS_UNIT_PF: CHAR(5) ELIMS_ONLY: CHAR(1) JRNL_BALANCE_OPTN: CHAR(1) JRNL_EDIT_ERR_OPTN: CHAR(1) JRNL_AMT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN2: CHAR(1) CONTROL_TOTAL_OPTN: CHAR(1) CURRENCY_BAL_OPTN: CHAR(1) BASE_CUR_ADJ_OPTN: CHAR(1) JRNL_FOREIGN_OPTN: CHAR(1) ENABLE_UNPOST_DT: CHAR(1) JRNL_APPRVL_OPTN: CHAR(1) STL_APPROVALS: CHAR(1) STL_APPROV_OPT: CHAR(1) BD_JRNL_APPR_OPTN: CHAR(1) BUSPROCNAME: CHAR(30) APPR_RULE_SET: CHAR(30) BUSPROCNAME_BD: CHAR(30) APPR_RULE_SET_BD: CHAR(30) TR_CONFIRM_SW: CHAR(1) TR_CONFO_MAIL_SW: CHAR(1) TR_PREAPPR_SW: CHAR(1) TR_RVL_RATE_INDEX: CHAR(10) TR_RVL_RT_TYPE: CHAR(5) TR_SCHD_POSN_CREAT: CHAR(1) TR_SCHD_RUN_CTL_ID: CHAR(30) TR_SCHD_RUNLOCN: CHAR(1) TR_SCHD_SERVERNAME: CHAR(8) TR_BX_APPL_JRNL_ID: CHAR(10) TR_CALENDAR_ID: CHAR(2) TRA_REVIEW_STATUS: CHAR(1) INT_ENTITYCD: CHAR(4) EXT_ENTITYCD: CHAR(4) PYMNT_METHOD: CHAR(3) DOC_SEQ: CHAR(1) DOC_TYPE: CHAR(8) VAT_CALC_TYPE: CHAR(1) VAT_TXN_TYPE_CD: CHAR(4) VAT_TOL_AMT: DECIMAL(26,3) VAT_TOL_CUR_CD: CHAR(3) VAT_TOL_PCT: DECIMAL(7,2) VAT_TOL_RT_TYPE: CHAR(5) TAX_CD_VAT: CHAR(8) VAT_USE_ID: CHAR(6) VAT_OVR_RCVRY_FLG: CHAR(1) VAT_NRCVR_PRO_FLG: CHAR(1) VAT_NRCVR_ALL_FLG: CHAR(1) VAT_APORT_CNTRL: CHAR(1) HOLIDAY_LIST_ID: CHAR(10) POST_DATE_OPTN: CHAR(1) PROCESS_DATE: PSDATE IU_INTER_TMPLT_CD: CHAR(5) IU_INTRA_TMPLT_CD: CHAR(5) IU_LEGAL_ENT_BU: CHAR(5) BUSINESS_UNIT_AP: CHAR(5) VENDOR_ID: CHAR(10) LOCATION: CHAR(10) BUSINESS_UNIT_BI: CHAR(5) CUST_ID: CHAR(15) OPERATING_UNIT: CHAR(8) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) CLASS_FLD: CHAR(5) PROGRAM_CODE: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) DEPTID: CHAR(10) CUST_VNDR_AFFILIAT: CHAR(1) LOAD_DTTM: PSDATETIME LASTUPDDTTM: PSDATETIME ERROR_FLAG: CHAR(1) PS_BP_LED_KK_F00 BUSINESS_UNIT: CHAR(5) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) SCENARIO: CHAR(10) STATISTICS_CODE: CHAR(3) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) BUDGET_PERIOD: CHAR(8) CURRENCY_CD: CHAR(3) KK_BUDG_TRANS_TYPE: CHAR(1) POSTED_TOTAL_AMT: DECIMAL(26,3) POSTED_BASE_AMT: DECIMAL(26,3) POSTED_TRAN_AMT: DECIMAL(26,3) BASE_CURRENCY: CHAR(3) DTTM_STAMP_SEC: PSDATETIME PROCESS_INSTANCE: DECIMAL(10) PS_BP_ASSET_EXT BP_BUDG_CNTR_RPT: CHAR(15) BUSINESS_UNIT: CHAR(5) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ASSET_ID: CHAR(12) BOOK: CHAR(10) ACCOUNT: CHAR(10) BUDGET_PERIOD: CHAR(8) BP_CASH_ACCOUNT: CHAR(10) BP_ASSET_ACCOUNT: CHAR(10) BP_DEPR_ACCOUNT: CHAR(10) SCENARIO: CHAR(10) DESCR: CHAR(30) ASSET_STATUS: CHAR(1) ACQUISITION_FY: SMALLINT ACQUISITION_AP: SMALLINT IN_SERVICE_FY: SMALLINT IN_SERVICE_AP: SMALLINT COST: DECIMAL(26,3) QUANTITY: DECIMAL(15,4) ASSET_CLASS: CHAR(10) PROFILE_ID: CHAR(10) METHOD: CHAR(2) SALVAGE_VALUE: DECIMAL(26,3) DISPOSAL_CODE: CHAR(1) PROCEEDS: DECIMAL(26,3) REMOVAL_COST: DECIMAL(26,3) LIFE: SMALLINT RETIREMENT_FY: SMALLINT RETIREMENT_AP: SMALLINT SPREADTYPE: SMALLINT SPREAD_TEMPLATE: CHAR(30) CAP_NUM: CHAR(15) CAP_SEQUENCE: SMALLINT CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BD_UPDATE_FLAG: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_EXCLUDE: CHAR(1) LASTUPDDTTM: PSDATETIME PS_BP_LINE_PRD_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_LINE_SEQ_NO: DECIMAL(15) (FK) BUDGET_PERIOD: CHAR(8) BP_AMT_BASE: DECIMAL(27,4) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) LASTUPDDTTM: PSDATETIME PS_BP_LN_ITEMS_EXT BP_BUDG_CNTR_RPT: CHAR(15) BUSINESS_UNIT: CHAR(5) BP_BUDGET_VERSION: CHAR(1) BP_LINE_SEQ_NO: DECIMAL(15) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_LINE_ERR_FLAG: CHAR(1) BP_LINE_MTHD_DEF: CHAR(6) METHOD_ID: CHAR(10) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_BASE: DECIMAL(27,4) BP_DRIVER_ID: CHAR(20) BP_ANAL_BASE_ID: CHAR(1) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) HOLD_FLAG: CHAR(1) BP_LINE_SPRD_TYP: CHAR(3) LASTUPDDTTM: PSDATETIME PS_BP_LN_AMUNT_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_LINE_SEQ_NO: DECIMAL(15) (FK) BUDGET_PERIOD: CHAR(8) BP_LINE_UNIT_COST: DECIMAL(31,8) BP_LINE_UNITS: DECIMAL(31,8) BP_LINE_REL_ACC: CHAR(10) BP_LINE_REL_STATCD: CHAR(3) BP_PERCENT_AMT_ID: CHAR(1) BP_CALC_AMOUNT: DECIMAL(27,4) LASTUPDDTTM: PSDATETIME

    PS_BP_LED_BUDG_F00 BUSINESS_UNIT: CHAR(5) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) SCENARIO: CHAR(10) STATISTICS_CODE: CHAR(3) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) CURRENCY_CD: CHAR(3) BOOK_CODE: CHAR(4) GL_ADJUST_TYPE: CHAR(4) POSTED_TOTAL_AMT: DECIMAL(26,3) POSTED_BASE_AMT: DECIMAL(26,3) POSTED_TRAN_AMT: DECIMAL(26,3) BASE_CURRENCY: CHAR(3) DTTM_STAMP_SEC: PSDATETIME PROCESS_INSTANCE: DECIMAL(10)

    PS_BP_LN_PCANN_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_LINE_SEQ_NO: DECIMAL(15) (FK) FISCAL_YEAR: SMALLINT BP_GROWTH_PERCENT: DECIMAL(11,8) BP_CALC_AMOUNT: DECIMAL(27,4) LASTUPDDTTM: PSDATETIME

    PS_BP_LN_PCPRD_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_LINE_SEQ_NO: DECIMAL(15) (FK) BUDGET_PERIOD: CHAR(8) BP_GROWTH_PERCENT: DECIMAL(11,8) BP_CALC_AMOUNT: DECIMAL(27,4) LASTUPDDTTM: PSDATETIME

    PS_BP_LED_PROJ_F00 BUSINESS_UNIT: CHAR(5) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) SCENARIO: CHAR(10) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) RESOURCE_ID: CHAR(40) CURRENCY_CD: CHAR(3) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) POSTED_TOTAL_AMT: DECIMAL(26,3) POSTED_BASE_AMT: DECIMAL(26,3) POSTED_TRAN_AMT: DECIMAL(26,3) BASE_CURRENCY: CHAR(3) DTTM_STAMP_SEC: PSDATETIME PC_DISTRIB_STATUS: CHAR(1) PROCESS_INSTANCE: DECIMAL(10)

    PS_BP_LED_F00 BUSINESS_UNIT: CHAR(5) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) STATISTICS_CODE: CHAR(3) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) CURRENCY_CD: CHAR(3) BOOK_CODE: CHAR(4) GL_ADJUST_TYPE: CHAR(4) POSTED_TOTAL_AMT: DECIMAL(26,3) POSTED_BASE_AMT: DECIMAL(26,3) POSTED_TRAN_AMT: DECIMAL(26,3) BASE_CURRENCY: CHAR(3) DTTM_STAMP_SEC: PSDATETIME PROCESS_INSTANCE: DECIMAL(10)

    PS_BP_ASST_DPR_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) ASSET_ID: CHAR(12) (FK) BUDGET_PERIOD: CHAR(8) BOOK: CHAR(10) ACCOUNT: CHAR(10) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) SCENARIO: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT DEPR: DECIMAL(26,3) NET_BK_VALUE: DECIMAL(26,3) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BD_UPDATE_FLAG: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_LINE_ITM_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_LINE_SEQ_NO: DECIMAL(15) (FK) BP_ITEMIZATION_NBR: INT BP_DESCR: CHAR(60) BP_LINE_UNITS: DECIMAL(31,8) BP_LINE_UNIT_COST: DECIMAL(31,8) BP_CALC_AMOUNT: DECIMAL(27,4) BUDGET_PERIOD_FROM: CHAR(8) BUDGET_PERIOD_TO: CHAR(8) BP_ITM_SPRD_TYP: CHAR(1) BP_DRIVER_ID: CHAR(20) LASTUPDDTTM: PSDATETIME

    PS_BP_TAX_DIS_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) TAX_CLASS: CHAR(1) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) PS_BP_LINE_PRD_ANL MSSCONCATCOL: CHAR(256) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BUSINESS_UNIT: CHAR(5) BP_LEDGER_NAME: CHAR(30) BP_LEDGER_NAME_TO: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) BUDGET_PERIOD: CHAR(8) BP_AMT_BASE: DECIMAL(27,4) PS_BP_LINE_PRD_STG MSSCONCATCOL: CHAR(256) PROCESS_INSTANCE: DECIMAL(10) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BUSINESS_UNIT: CHAR(5) BP_LINE_SEQ_NO: DECIMAL(15) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BUDGET_PERIOD: CHAR(8) BP_AMT_BASE: DECIMAL(27,4) BP_AMOUNT: DECIMAL(27,4) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_TOT: DECIMAL(27,4) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_MAX_GROSS: INT BP_TAX_PERCENT: DECIMAL(5,2) BP_TAX_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_SAL_DIS_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFDT: PSDATE EFFSEQ: SMALLINT (FK) DISTR_SEQ_NBR: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) TOTAL_SALARY: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_LINE_STG MSSCONCATCOL: CHAR(256) PROCESS_INSTANCE: DECIMAL(10) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BUSINESS_UNIT: CHAR(5) BP_LINE_SEQ_NO: DECIMAL(15) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_LINE_ERR_FLAG: CHAR(1) BP_LINE_MTHD_DEF: CHAR(6) METHOD_ID: CHAR(10) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_ADJ_ALLOC: DECIMAL(27,4) BP_AMT_TOT: DECIMAL(27,4) BP_AMT_BASE: DECIMAL(27,4) BP_DRIVER_ID: CHAR(20) BP_ANAL_BASE_ID: CHAR(1) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) BP_LINE_PCT_ACC: DECIMAL(5,2) BP_LINE_REL_ACC: CHAR(10) HOLD_FLAG: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_BNFT_DIS_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) PLAN_TYPE: CHAR(2) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BNFT_PERCENT: DECIMAL(5,2) BP_BNFT_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_LINE_PRD_ANP MSSCONCATCOL: CHAR(256) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BUSINESS_UNIT: CHAR(5) BP_LEDGER_NAME: CHAR(30) BP_LEDGER_NAME_TO: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BUDGET_PERIOD: CHAR(8) BP_AMT_BASE: DECIMAL(27,4)

    PS_BP_EARN_DIS_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) BP_EARN_CD: CHAR(3) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_EARN_PERCENT: DECIMAL(5,2) BP_EARN_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) ADD_GROSS: CHAR(1) BP_ONETIMEPAY: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_JOB_EXT BP_BUDG_CNTR_RPT: CHAR(15) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) JOBCODE: CHAR(6) FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) UNION_CD: CHAR(3) ORIGNL_CURRENCY_CD: CHAR(3) BP_BARG_ID: CHAR(10) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FICA_STATUS_EE: CHAR(1) CURRENCY_CD: CHAR(3) BP_TOTAL_SALARY: DECIMAL(26,3) BP_TOTAL_EARNING: DECIMAL(26,3) BP_ALLOWANCE: DECIMAL(26,3) BP_ONE_TIME_PAY: DECIMAL(26,3) BP_TOTAL_BNFT: DECIMAL(26,3) BP_TOTAL_TAX: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) HR_POS_CONTROL: CHAR(10) LOCATION: CHAR(10) LASTUPDDTTM: PSDATETIME

    PS_BP_POSITION_EXT BP_BUDG_CNTR_RPT: CHAR(15) BUSINESS_UNIT: CHAR(5) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) POSITION_NBR: CHAR(8) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) HR_POS_CONTROL: CHAR(10) JOBCODE: CHAR(6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) MAX_HEAD_COUNT: SMALLINT UNION_CD: CHAR(3) BP_EXCLUDE: CHAR(1) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) BP_BUDG_FACTOR: DECIMAL(4,2) UPDATE_INCUMBENTS: CHAR(1) BP_FROM_INTRFC: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) POSN_STATUS: CHAR(1) BUSINESS_UNIT_HR: CHAR(5) BP_BUDG_IMPACT: DECIMAL(31,3) BP_POS_STATUS: CHAR(1) LASTUPDDTTM: PSDATETIME

    PS_BP_BNFT_DIS_EXP BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) PLAN_TYPE: CHAR(2) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) BP_EXPORT_SEQ: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BNFT_PERCENT: DECIMAL(5,2) BP_BNFT_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) LEDGER: CHAR(10) SCENARIO: CHAR(10)

    PS_BP_JOB_EXP BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT BP_EXPORT_SEQ: CHAR(30) POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) JOBCODE: CHAR(6) FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) UNION_CD: CHAR(3) ORIGNL_CURRENCY_CD: CHAR(3) BP_BARG_ID: CHAR(10) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FICA_STATUS_EE: CHAR(1) BP_TOTAL_SALARY: DECIMAL(26,3) BP_TOTAL_EARNING: DECIMAL(26,3) BP_ALLOWANCE: DECIMAL(26,3) BP_ONE_TIME_PAY: DECIMAL(26,3) BP_TOTAL_BNFT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) HR_POS_CONTROL: CHAR(10) LOCATION: CHAR(10)

    PS_BP_POSITION_EXP BUSINESS_UNIT: CHAR(5) POSITION_NBR: CHAR(8) EFFDT: PSDATE BP_EXPORT_SEQ: CHAR(30) EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) HR_POS_CONTROL: CHAR(10) JOBCODE: CHAR(6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) MAX_HEAD_COUNT: SMALLINT UNION_CD: CHAR(3) BP_EXCLUDE: CHAR(1) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) BP_BUDG_FACTOR: DECIMAL(4,2) UPDATE_INCUMBENTS: CHAR(1) BP_FROM_INTRFC: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) POSN_STATUS: CHAR(1) BUSINESS_UNIT_HR: CHAR(5)

    PS_BP_ASSET_STG MSSCONCATCOL: CHAR(256) PS_BP_ASST_DEP_STG MSSCONCATCOL: CHAR(256) PROCESS_INSTANCE: DECIMAL(10) BP_LEDGER_NAME: CHAR(30) BUSINESS_UNIT: CHAR(5) BOOK: CHAR(10) ASSET_ID: CHAR(12) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) SCENARIO: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT DEPR: DECIMAL(26,3) NET_BK_VALUE: DECIMAL(26,3) BUDGET_PERIOD: CHAR(8) BD_UPDATE_FLAG: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30) PROCESS_INSTANCE: DECIMAL(10) BP_LEDGER_NAME: CHAR(30) BUSINESS_UNIT: CHAR(5) BOOK: CHAR(10) ASSET_ID: CHAR(12) BUDGET_PERIOD: CHAR(8) BP_CASH_ACCOUNT: CHAR(10) BP_ASSET_ACCOUNT: CHAR(10) BP_DEPR_ACCOUNT: CHAR(10) SCENARIO: CHAR(10) DESCR: CHAR(30) ASSET_STATUS: CHAR(1) ACQUISITION_FY: SMALLINT ACQUISITION_AP: SMALLINT IN_SERVICE_FY: SMALLINT IN_SERVICE_AP: SMALLINT COST: DECIMAL(26,3) QUANTITY: DECIMAL(15,4) ASSET_CLASS: CHAR(10) PROFILE_ID: CHAR(10) METHOD: CHAR(2) SALVAGE_VALUE: DECIMAL(26,3) DISPOSAL_CODE: CHAR(1) PROCEEDS: DECIMAL(26,3) REMOVAL_COST: DECIMAL(26,3) LIFE: SMALLINT RETIREMENT_FY: SMALLINT RETIREMENT_AP: SMALLINT SPREADTYPE: SMALLINT SPREAD_TEMPLATE: CHAR(30) CAP_NUM: CHAR(15) CAP_SEQUENCE: SMALLINT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BD_UPDATE_FLAG: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30) BP_EXCLUDE: CHAR(1) PS_BP_LINE_ITM_EXP MSSCONCATCOL: CHAR(256) BP_EXPORT_SEQ: CHAR(30) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_BUDG_CNTR_ADV: CHAR(30) BP_ITEMIZATION_NBR: INT BP_DESCR: CHAR(60) BP_LINE_UNITS: DECIMAL(31,8) BP_LINE_UNIT_COST: DECIMAL(31,8) BP_CALC_AMOUNT: DECIMAL(27,4) BUDGET_PERIOD_FROM: CHAR(8) BUDGET_PERIOD_TO: CHAR(8) BP_ITM_SPRD_TYP: CHAR(1) BP_DRIVER_ID: CHAR(20)

    PS_BP_TAX_DIS_EXP BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) TAX_CLASS: CHAR(1) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) BP_EXPORT_SEQ: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_MAX_GROSS: INT BP_TAX_PERCENT: DECIMAL(5,2) BP_TAX_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_EARN_DIS_EXP BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) BP_EARN_CD: CHAR(3) EMPL_RCD_NUM: SMALLINT (FK) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT (FK) BP_EXPORT_SEQ: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_EARN_PERCENT: DECIMAL(5,2) BP_EARN_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) ADD_GROSS: CHAR(1) BP_ONETIMEPAY: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) LEDGER: CHAR(10) SCENARIO: CHAR(10)

    PS_BP_LINE_NT_EXP BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_LINE_SEQ_NO: DECIMAL(15) BP_SEQUENCE_NUM: INT BP_EXPORT_SEQ: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_OPRID: CHAR(30) BP_PUB_PRIVATE_IND: CHAR(3) BP_DTTM_STAMP: PSDATETIME BP_ITEM_NOTES: TEXT

    PS_BP_LEDGER_BDEXP BP_EXPORT_SEQ: CHAR(30) BUSINESS_UNIT: CHAR(5) LEDGER: CHAR(10) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) RESOURCE_ID: CHAR(40) BUDGET_PERIOD: CHAR(8) SCENARIO: CHAR(10) FISCAL_YEAR: SMALLINT ACCOUNTING_PERIOD: SMALLINT BP_POSTED_TOT_AMT: DECIMAL(27,4) BP_POSTED_BASE_AMT: DECIMAL(27,4) BP_POSTED_TRAN_AMT: DECIMAL(27,4) BASE_CURRENCY: CHAR(3) BP_LEDGER_NAME: CHAR(30)

    PS_BP_SAL_DIS_EXP BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFDT: PSDATE EFFSEQ: SMALLINT (FK) DISTR_SEQ_NBR: SMALLINT BP_EXPORT_SEQ: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) TOTAL_SALARY: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) LEDGER: CHAR(10) SCENARIO: CHAR(10)

    PS_BP_LINE_ADJ_EXT BP_BUDG_CNTR_RPT: CHAR(15) BUSINESS_UNIT: CHAR(5) BP_BUDGET_VERSION: CHAR(1) BP_LINE_SEQ_NO: DECIMAL(15) BP_ADJUSTMENT_ID: CHAR(15) BP_ADJ_SEQ_NO: DECIMAL(15) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BUDGET_PERIOD: CHAR(8) BP_ADJ_BUD_CTR: CHAR(31) BP_ADJ_AMT: DECIMAL(27,4) BP_ADJ_STATUS: CHAR(1) LASTUPDDTTM: PSDATETIME

    PS_BP_ALLC_AMT_EXT BP_BUDG_CNTR_RPT: CHAR(15) BUSINESS_UNIT: CHAR(5) BP_LINE_SEQ_NO: DECIMAL(15) BP_ALLOCATION_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) BP_ALLC_AMT_TYP: CHAR(1) BP_ALLC_AMT: DECIMAL(27,4) BP_ALLC_PCT: DECIMAL(8,5) BP_INIT_BUD_CENTER: CHAR(15) LASTUPDDTTM: PSDATETIME

    PS_BP_POSITION_STG BUSINESS_UNIT: CHAR(5) POSITION_NBR: CHAR(8) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) HR_POS_CONTROL: CHAR(10) JOBCODE: CHAR(6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) MAX_HEAD_COUNT: SMALLINT BP_EXCLUDE: CHAR(1) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) BP_BUDG_FACTOR: DECIMAL(4,2) UPDATE_INCUMBENTS: CHAR(1) BP_FROM_INTRFC: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) POSN_STATUS: CHAR(1) BUSINESS_UNIT_HR: CHAR(5) UNION_CD: CHAR(3)

    PS_BP_JOB_STG BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) JOBCODE: CHAR(6) FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) BP_BARG_ID: CHAR(10) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FICA_STATUS_EE: CHAR(1) BP_TOTAL_SALARY: DECIMAL(26,3) BP_TOTAL_EARNING: DECIMAL(26,3) BP_ALLOWANCE: DECIMAL(26,3) BP_TOTAL_BNFT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) HR_POS_CONTROL: CHAR(10) LOCATION: CHAR(10) UNION_CD: CHAR(3) ORIGNL_CURRENCY_CD: CHAR(3) CURRENCY_CD: CHAR(3)

    PS_BP_TAX_DIS_STG BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) TAX_CLASS: CHAR(1) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_MAX_GROSS: INT BP_TAX_PERCENT: DECIMAL(5,2) BP_TAX_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_EARN_DIS_CCY PROCESS_INSTANCE: DECIMAL(10) (FK) EFFDT: PSDATE (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) BP_EARN_CD: CHAR(3) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE BUDGET_PERIOD: CHAR(8) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_EARN_PERCENT: DECIMAL(5,2) BP_EARN_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) ADD_GROSS: CHAR(1) AMOUNT: DECIMAL(26,3) BP_ONETIMEPAY: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_SAL_DIS_STG BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) EFFDT: PSDATE ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_PERCENTAGE: DECIMAL(7,2) DISTR_SEQ_NBR: SMALLINT AMOUNT: DECIMAL(26,3) TOTAL_SALARY: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_BNFT_DIS_CCY PROCESS_INSTANCE: DECIMAL(10) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) PLAN_TYPE: CHAR(2) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE BUDGET_PERIOD: CHAR(8) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BNFT_PERCENT: DECIMAL(5,2) BP_BNFT_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_JOB_CCY PROCESS_INSTANCE: DECIMAL(10) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_LEDGER_NAME: CHAR(30) POSITION_NBR: CHAR(8) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) JOBCODE: CHAR(6) FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) BP_BARG_ID: CHAR(10) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FICA_STATUS_EE: CHAR(1) BP_TOTAL_SALARY: DECIMAL(26,3) BP_TOTAL_EARNING: DECIMAL(26,3) BP_ALLOWANCE: DECIMAL(26,3) BP_TOTAL_BNFT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30) HR_POS_CONTROL: CHAR(10) LOCATION: CHAR(10) UNION_CD: CHAR(3) ORIGNL_CURRENCY_CD: CHAR(3) CURRENCY_CD: CHAR(3)

    PS_BP_SAL_DIS_CCY PROCESS_INSTANCE: DECIMAL(10) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) EFFDT: PSDATE DISTR_SEQ_NBR: SMALLINT BUDGET_PERIOD: CHAR(8) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) TOTAL_SALARY: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_EARN_DIS_STG BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) BP_EARN_CD: CHAR(3) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_EARN_PERCENT: DECIMAL(5,2) BP_EARN_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) ADD_GROSS: CHAR(1) AMOUNT: DECIMAL(26,3) BP_ONETIMEPAY: CHAR(1) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_TAX_DIS_CCY PROCESS_INSTANCE: DECIMAL(10) (FK) BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) TAX_CLASS: CHAR(1) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE BUDGET_PERIOD: CHAR(8) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_MAX_GROSS: INT BP_TAX_PERCENT: DECIMAL(5,2) BP_TAX_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_BNFT_DIS_STG BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFSEQ: SMALLINT (FK) MSSCONCATCOL: CHAR(256) PLAN_TYPE: CHAR(2) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BNFT_PERCENT: DECIMAL(5,2) BP_BNFT_AMOUNT: DECIMAL(26,3) BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    1, 1 / 1, 1 -- 1:26:24 PM , 9/3/2004

    BUDGETSALLOCATION -- Physical / <Main Subject Area>


    PS_BP_ALLC_SRC_CFS BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) FIELD_SEQUENCE: SMALLINT NOT NULL BP_CHECKOUTID: CHAR(33) NOT NULL (FK) CHARTFIELD: CHAR(18) NOT NULL FROM_VALUE: CHAR(30) NOT NULL TO_VALUE: CHAR(30) NOT NULL

    PS_BP_ALLC_SRC_AMT BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) BP_CHECKOUTID: CHAR(33) NOT NULL (FK) MSSCONCATCOL: CHAR(256) NOT NULL ACCOUNT: CHAR(10) NOT NULL ALTACCT: CHAR(10) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL STATISTICS_CODE: CHAR(3) NOT NULL PROJECT_ID: CHAR(15) NOT NULL BUDGET_PERIOD: CHAR(8) NOT NULL OPERATING_UNIT: CHAR(8) NOT NULL DEPTID: CHAR(10) NOT NULL PRODUCT: CHAR(6) NOT NULL FUND_CODE: CHAR(5) NOT NULL PROGRAM_CODE: CHAR(5) NOT NULL CLASS_FLD: CHAR(5) NOT NULL BUDGET_REF: CHAR(8) NOT NULL AFFILIATE: CHAR(5) NOT NULL AFFILIATE_INTRA1: CHAR(10) NOT NULL AFFILIATE_INTRA2: CHAR(10) NOT NULL CHARTFIELD1: CHAR(10) NOT NULL CHARTFIELD2: CHAR(10) NOT NULL CHARTFIELD3: CHAR(10) NOT NULL BUSINESS_UNIT_PC: CHAR(5) NOT NULL ACTIVITY_ID: CHAR(15) NOT NULL RESOURCE_TYPE: CHAR(5) NOT NULL ANALYSIS_TYPE: CHAR(3) NOT NULL RESOURCE_CATEGORY: CHAR(5) NOT NULL RESOURCE_SUB_CAT: CHAR(5) NOT NULL BP_SOURCE_AMOUNT: DECIMAL(27,4) NOT NULL BP_SOURCE_PCT: DECIMAL(8,5) NOT NULL BP_AMT_ADJ: DECIMAL(27,4) NOT NULL BP_AMT_MTHD: DECIMAL(27,4) NOT NULL

    PS_BP_ALLC_SOURCE BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) BP_CHECKOUTID: CHAR(33) NOT NULL (FK) BUDGET_PERIOD: CHAR(8) NOT NULL BP_BUDGET_CATEGORY: CHAR(15) NOT NULL BP_TOT_SOURCE: DECIMAL(27,4) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL 1

    PS_BP_ADV_CHECKOUT BP_CHECKOUTID: CHAR(33) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL BP_PLANNING_ID: CHAR(15) NOT NULL BUDGET_PHASE_ID: CHAR(30) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL BP_BUDGET_VERSION: CHAR(1) NOT NULL BP_BUDGET_VER_ID: CHAR(1) NOT NULL BP_ADV_ROLENAME: CHAR(80) NOT NULL SCENARIO: CHAR(10) NOT NULL OPRID: CHAR(30) NOT NULL TRANSACTION_ID: CHAR(10) NOT NULL READ_ONLY_FLAG: CHAR(1) NOT NULL BP_CHECKOUT_DT: PSDATETIME NULL TYPE: CHAR(1) NOT NULL BAM_MODEL_ID: CHAR(20) NOT NULL

    PS_BP_ALLC_SUM BUSINESS_UNIT: CHAR(5) NOT NULL BP_ALLOCATION_ID: CHAR(15) NOT NULL BP_CHECKOUTID: CHAR(33) NOT NULL (FK) BP_PLANNING_ID: CHAR(15) NOT NULL BUDGET_PHASE_ID: CHAR(30) NOT NULL BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL BP_LEDGER_NAME: CHAR(30) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL BP_TARGET_SUM: DECIMAL(27,4) NOT NULL ALLOC_SELECT: CHAR(1) NOT NULL BP_INIT_BUD_CENTER: CHAR(15) NOT NULL BP_TARGET_FLAG: CHAR(1) NOT NULL BP_STAT_BUDG_FLG: CHAR(1) NOT NULL BP_EXECUTE_FLAG: CHAR(1) NOT NULL

    PS_BP_ALLC_TGT_AMT BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) BP_CHECKOUTID: CHAR(33) NOT NULL (FK) MSSCONCATCOL: CHAR(256) NOT NULL ACCOUNT: CHAR(10) NOT NULL ALTACCT: CHAR(10) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL STATISTICS_CODE: CHAR(3) NOT NULL PROJECT_ID: CHAR(15) NOT NULL BUDGET_PERIOD: CHAR(8) NOT NULL OPERATING_UNIT: CHAR(8) NOT NULL DEPTID: CHAR(10) NOT NULL PRODUCT: CHAR(6) NOT NULL FUND_CODE: CHAR(5) NOT NULL PROGRAM_CODE: CHAR(5) NOT NULL CLASS_FLD: CHAR(5) NOT NULL BUDGET_REF: CHAR(8) NOT NULL AFFILIATE: CHAR(5) NOT NULL AFFILIATE_INTRA1: CHAR(10) NOT NULL AFFILIATE_INTRA2: CHAR(10) NOT NULL CHARTFIELD1: CHAR(10) NOT NULL CHARTFIELD2: CHAR(10) NOT NULL CHARTFIELD3: CHAR(10) NOT NULL BUSINESS_UNIT_PC: CHAR(5) NOT NULL ACTIVITY_ID: CHAR(15) NOT NULL RESOURCE_TYPE: CHAR(5) NOT NULL ANALYSIS_TYPE: CHAR(3) NOT NULL RESOURCE_CATEGORY: CHAR(5) NOT NULL RESOURCE_SUB_CAT: CHAR(5) NOT NULL BP_TARGET_AMOUNT: DECIMAL(27,4) NOT NULL BP_TARGET_PCT: DECIMAL(8,5) NOT NULL BP_AMT_ADJ: DECIMAL(27,4) NOT NULL BP_AMT_MTHD: DECIMAL(27,4) NOT NULL

    PS_BP_ALLC_TARGET BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) BP_CHECKOUTID: CHAR(33) NOT NULL (FK) BUDGET_PERIOD: CHAR(8) NOT NULL 1 BP_BUDGET_CATEGORY: CHAR(15) NOT NULL BP_ALLOC_SPREAD: CHAR(3) NOT NULL BP_TOT_TARGET: DECIMAL(27,4) NOT NULL CURRENCY_CD: CHAR(3) NOT NULL

    PS_BP_ALLC_TGT_CFS BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_ALLOCATION_ID: CHAR(15) NOT NULL (FK) FIELD_SEQUENCE: SMALLINT NOT NULL BP_CHECKOUTID: CHAR(33) NOT NULL (FK) CHARTFIELD: CHAR(18) NOT NULL FROM_VALUE: CHAR(30) NOT NULL TO_VALUE: CHAR(30) NOT NULL

    1, 1 / 1, 1 -- 1:27:16 PM , 9/3/2004

    LINEITEM BUDGETING -- Physical / <Main Subject Area>


    PS_BP_LINE_GRID BP_CHECKOUTID: CHAR(33) (FK) TREE_NODE_NUM: INT CF_SORT_1: CHAR(15) CF_SORT_2: CHAR(15) CF_SORT_3: CHAR(15) BP_LINE_SEQ_NO: DECIMAL(15) AMT_TYPE: CHAR(1) ENTRY_TARGET_FLAG: CHAR(1) CURRENCY_CD: CHAR(3) MSSCONCATCOL: CHAR(256) (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_LINE_ERR_FLAG: CHAR(1) TREE_LEVEL_NUM: SMALLINT TREE_NODE_NUM_END: INT TREE_NODE: CHAR(20) BP_LINE_MTHD_DEF: CHAR(6) METHOD_ID: CHAR(10) BP_AMOUNT: DECIMAL(27,4) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) HOLD_FLAG: CHAR(1) EXPANDED_FLAG: CHAR(1) VISIBLE_FLAG: CHAR(1) DIRTY_FLAG: CHAR(1) FILTER_FLAG: CHAR(1) GRAY_FLAG: CHAR(1) SOURCE_FLAG: CHAR(1) STATISTICS_FLAG: CHAR(1) COL1: DECIMAL(27,4) COL2: DECIMAL(27,4) COL3: DECIMAL(27,4) COL4: DECIMAL(27,4) COL5: DECIMAL(27,4) COL6: DECIMAL(27,4) COL7: DECIMAL(27,4) COL8: DECIMAL(27,4) COL9: DECIMAL(27,4) COL10: DECIMAL(27,4) COL11: DECIMAL(27,4) COL12: DECIMAL(27,4) COL13: DECIMAL(27,4) COL14: DECIMAL(27,4) COL15: DECIMAL(27,4) COL16: DECIMAL(27,4) COL17: DECIMAL(27,4) COL18: DECIMAL(27,4) PS_BP_LINE_ITEMS BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_LINE_ERR_FLAG: CHAR(1) BP_LINE_MTHD_DEF: CHAR(6) METHOD_ID: CHAR(10) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_ADJ_ALLOC: DECIMAL(27,4) BP_AMT_TOT: DECIMAL(27,4) BP_AMT_BASE: DECIMAL(27,4) BP_DRIVER_ID: CHAR(20) BP_ANAL_BASE_ID: CHAR(1) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) HOLD_FLAG: CHAR(1) BP_BUDG_CNTR_ADV: CHAR(30) BP_LINE_SPRD_TYP: CHAR(3) 1 1 PS_BP_LINE_PRD_DTL BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_AMT_BASE: DECIMAL(27,4) BP_AMOUNT: DECIMAL(27,4) BP_AMT_MTHD: DECIMAL(27,4) BP_AMT_ADJ: DECIMAL(27,4) BP_AMT_ALLOC: DECIMAL(27,4) BP_AMT_TOT: DECIMAL(27,4) BP_AMT_PRIOR_ACT: DECIMAL(27,4) BP_AMT_YTD_ACT: DECIMAL(27,4) BP_AMT_CURR_BUDG: DECIMAL(27,4) BP_AMT_CURR_FORC: DECIMAL(27,4) BP_AMT_HISTORY_1: DECIMAL(27,4) BP_AMT_HISTORY_2: DECIMAL(27,4) BP_AMT_HISTORY_3: DECIMAL(27,4) BP_AMT_HISTORY_4: DECIMAL(27,4) BP_AMT_HISTORY_5: DECIMAL(27,4) PS_BP_TGT_LINE BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) FISCAL_YEAR: SMALLINT BP_LINE_ERR_FLAG: CHAR(1) BP_AMT_TOT: DECIMAL(27,4) BP_AMT_BASE: DECIMAL(27,4) BP_BUDG_CNTR_ADV: CHAR(30) TREE_LEVEL_NUM: SMALLINT PARENT_NODE: CHAR(30) EXIST: CHAR(1) ROW_COUNT: INT PROCESS_INSTANCE: DECIMAL(10) PS_BP_LINE_NOTES BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BP_SEQUENCE_NUM: INT ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_OPRID: CHAR(30) BP_PUB_PRIVATE_IND: CHAR(3) BP_DTTM_STAMP: PSDATETIME BP_ITEM_NOTES: TEXT PS_BP_LINE_AMTUNT BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_LINE_UNIT_COST: DECIMAL(31,8) BP_LINE_UNITS: DECIMAL(31,8) BP_LINE_REL_ACC: CHAR(10) BP_LINE_REL_STATCD: CHAR(3) BP_PERCENT_AMT_ID: CHAR(1) BP_CALC_AMOUNT: DECIMAL(27,4) PS_BP_LINE_ITM BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_BUDG_CNTR_ADV: CHAR(30) BP_ITEMIZATION_NBR: INT BP_DESCR: CHAR(60) BP_LINE_UNITS: DECIMAL(31,8) BP_LINE_UNIT_COST: DECIMAL(31,8) BP_CALC_AMOUNT: DECIMAL(27,4) BUDGET_PERIOD_FROM: CHAR(8) BUDGET_PERIOD_TO: CHAR(8) BP_ITM_SPRD_TYP: CHAR(1) BP_DRIVER_ID: CHAR(20) PS_BP_TGT_LEDP_EX BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) SCENARIO: CHAR(10) FISCAL_YEAR: SMALLINT POSTED_BASE_AMT: DECIMAL(26,3) TREE_LEVEL_NUM: SMALLINT PARENT_NODE_NAME: CHAR(20) PS_BP_PHASE_LEDGER BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_LEDGER_NAME: CHAR(30) ALLOW_UPDATE_FLG: CHAR(1) FIRST_PERIOD_UPDT: CHAR(8) ACCOUNTING_PERIOD: SMALLINT ENFORCE_BUDGET: CHAR(1) BASE_BUDGET: CHAR(30) BUDGET_FACTOR: DECIMAL(5,2) ZBB: CHAR(1) BP_ASSET_CHK: CHAR(1) BP_POS_CHK: CHAR(1) PS_BP_TGT_LEDC_EX BUSINESS_UNIT: CHAR(5) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) SCENARIO: CHAR(10) POSTED_BASE_AMT: DECIMAL(26,3) TREE_LEVEL_NUM: SMALLINT PARENT_NODE_NAME: CHAR(20) PS_BP_TGT_LEDB_EX BUSINESS_UNIT: CHAR(5) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) MSSCONCATCOL: CHAR(256) LEDGER: CHAR(10) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) SCENARIO: CHAR(10) FISCAL_YEAR: SMALLINT POSTED_BASE_AMT: DECIMAL(26,3) TREE_LEVEL_NUM: SMALLINT PARENT_NODE_NAME: CHAR(20) PS_BP_TGT_CNTL_LVL SETID: CHAR(5) (FK) BP_TGT_CNTL_GRP_ID: CHAR(15) (FK) EFFDT: PSDATE (FK) ROLENAME: CHAR(30) BP_TGT_CNTL_TYPE: CHAR(1) BP_TGT_TOL_ID: CHAR(15)

    PS_BP_LINE_CAL_SUM BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) PAGE_YEAR: SMALLINT BUDGET_PHASE_ID: CHAR(30) (FK) SQLTEXT: TEXT

    PS_BP_TGT_CONTROL SETID: CHAR(5) BP_TGT_CNTL_GRP_ID: CHAR(15) EFFDT: PSDATE EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3)

    PS_BP_PLAN_BUD_PER BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BUDGET_PERIOD: CHAR(8) BUDGET_PHASE_ID: CHAR(30) (FK) BEGIN_DT: PSDATE END_DT: PSDATE FISCAL_YEAR: SMALLINT

    PS_BP_LINE_CAL_NAM BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) PAGE_YEAR: SMALLINT COL_NUM: SMALLINT BUDGET_PHASE_ID: CHAR(30) (FK) PERIOD_HEADING: CHAR(10)

    PS_BP_TGT_CF_VALID BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) CHARTFIELD: CHAR(18) BUDGET_PHASE_ID: CHAR(30) (FK) VALID_TOTALS: CHAR(1) TREE_NAME: CHAR(18) TREE_SETID: CHAR(5) TREE_LEVEL_NUM: SMALLINT

    PS_BP_LINE_CAL_XTB BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BP_LEDGER_NAME: CHAR(30) BUDGET_PERIOD: CHAR(8) PAGE_YEAR: SMALLINT COL1_FLAG: SMALLINT COL2_FLAG: SMALLINT COL3_FLAG: SMALLINT COL4_FLAG: SMALLINT COL5_FLAG: SMALLINT COL6_FLAG: SMALLINT COL7_FLAG: SMALLINT COL8_FLAG: SMALLINT COL9_FLAG: SMALLINT COL10_FLAG: SMALLINT COL11_FLAG: SMALLINT COL12_FLAG: SMALLINT COL13_FLAG: SMALLINT COL14_FLAG: SMALLINT COL15_FLAG: SMALLINT COL16_FLAG: SMALLINT COL17_FLAG: SMALLINT COL18_FLAG: SMALLINT

    PS_BP_VERSION_TBL BP_BUDGET_VERSION: CHAR(1) BP_VER_SHORT_NAME: CHAR(6) BP_VERSION_NAME: CHAR(30)

    PS_BP_VER_MATRIX BP_BUDGET_VERSION: CHAR(1) BP_SUBMIT_VERSION: CHAR(1) BP_TO_VERSION: CHAR(1)

    PS_BP_LINE_AMT_XT AMT_TYPE: CHAR(1) BP_AMT_MTHD_FLAG: SMALLINT BP_AMT_ADJ_FLAG: SMALLINT BP_AMT_ALLOC_FLAG: SMALLINT BP_AMT_TOT_FLAG: SMALLINT

    PS_BP_LINE_PCT_PRD BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) BP_GROWTH_PERCENT: DECIMAL(11,8) BP_CALC_AMOUNT: DECIMAL(27,4)

    PS_BP_LINE_PCT_ANN BP_CHECKOUTID: CHAR(33) (FK) MSSCONCATCOL: CHAR(256) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) FISCAL_YEAR: SMALLINT BP_GROWTH_PERCENT: DECIMAL(11,8) BP_CALC_AMOUNT: DECIMAL(27,4)

    PS_BP_ADV_CHECKOUT BP_CHECKOUTID: CHAR(33) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_BUDGET_VER_ID: CHAR(1) BP_ADV_ROLENAME: CHAR(80) SCENARIO: CHAR(10) OPRID: CHAR(30) TRANSACTION_ID: CHAR(10) READ_ONLY_FLAG: CHAR(1) BP_CHECKOUT_DT: PSDATETIME TYPE: CHAR(1) BAM_MODEL_ID: CHAR(20)

    PS_BP_LINE_SELECT BP_CHECKOUTID: CHAR(33) (FK) BP_LINE_SEQ_NO: DECIMAL(15) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_USRVIEW_NAME: CHAR(30) BP_PUBLIC_FLG: CHAR(1) PAGE_YEAR: SMALLINT TREE_LEVEL_NUM: SMALLINT BP_PLAN_TGT_FLG: CHAR(1)

    PS_BP_LINE_SEL_CFS BP_CHECKOUTID: CHAR(33) (FK) FIELD_SEQUENCE: SMALLINT CHARTFIELD: CHAR(18) BP_DIMENSION_LEVEL: CHAR(1) BP_SHOW_CF_CODE: CHAR(1) BP_SHOW_CF_DESCR: CHAR(1) FROM_VALUE: CHAR(30) TO_VALUE: CHAR(30) BP_BUDGET_CATEGORY: CHAR(15)

    PS_BUS_UNIT_TBL_G BUSINESS_UNIT: CHAR(5) AS_OF_DATE: PSDATE BASE_CURRENCY: CHAR(3) BUSINESS_UNIT_PF: CHAR(5) ELIMS_ONLY: CHAR(1) JRNL_BALANCE_OPTN: CHAR(1) JRNL_EDIT_ERR_OPTN: CHAR(1) JRNL_AMT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN2: CHAR(1) CONTROL_TOTAL_OPTN: CHAR(1) CURRENCY_BAL_OPTN: CHAR(1) BASE_CUR_ADJ_OPTN: CHAR(1) JRNL_FOREIGN_OPTN: CHAR(1) ENABLE_UNPOST_DT: CHAR(1) JRNL_APPRVL_OPTN: CHAR(1) STL_APPROVALS: CHAR(1) STL_APPROV_OPT: CHAR(1) BD_JRNL_APPR_OPTN: CHAR(1) BUSPROCNAME: CHAR(30) APPR_RULE_SET: CHAR(30) BUSPROCNAME_BD: CHAR(30) APPR_RULE_SET_BD: CHAR(30) TR_CONFIRM_SW: CHAR(1) TR_CONFO_MAIL_SW: CHAR(1) TR_PREAPPR_SW: CHAR(1) TR_RVL_RATE_INDEX: CHAR(10) TR_RVL_RT_TYPE: CHAR(5) TR_SCHD_POSN_CREAT: CHAR(1) TR_SCHD_RUN_CTL_ID: CHAR(30) TR_SCHD_RUNLOCN: CHAR(1) TR_SCHD_SERVERNAME: CHAR(8) TR_BX_APPL_JRNL_ID: CHAR(10) TR_CALENDAR_ID: CHAR(2) TRA_REVIEW_STATUS: CHAR(1) INT_ENTITYCD: CHAR(4) EXT_ENTITYCD: CHAR(4) PYMNT_METHOD: CHAR(3) DOC_SEQ: CHAR(1) DOC_TYPE: CHAR(8) VAT_CALC_TYPE: CHAR(1) VAT_TXN_TYPE_CD: CHAR(4) VAT_TOL_AMT: DECIMAL(26,3) VAT_TOL_CUR_CD: CHAR(3) VAT_TOL_PCT: DECIMAL(7,2) VAT_TOL_RT_TYPE: CHAR(5) TAX_CD_VAT: CHAR(8) VAT_USE_ID: CHAR(6) VAT_OVR_RCVRY_FLG: CHAR(1) VAT_NRCVR_PRO_FLG: CHAR(1) VAT_NRCVR_ALL_FLG: CHAR(1) VAT_APORT_CNTRL: CHAR(1) HOLIDAY_LIST_ID: CHAR(10) POST_DATE_OPTN: CHAR(1) PROCESS_DATE: PSDATE IU_INTER_TMPLT_CD: CHAR(5) IU_INTRA_TMPLT_CD: CHAR(5) IU_LEGAL_ENT_BU: CHAR(5) BUSINESS_UNIT_AP: CHAR(5) VENDOR_ID: CHAR(10) LOCATION: CHAR(10) BUSINESS_UNIT_BI: CHAR(5) CUST_ID: CHAR(15) OPERATING_UNIT: CHAR(8) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) CLASS_FLD: CHAR(5) PROGRAM_CODE: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) DEPTID: CHAR(10) CUST_VNDR_AFFILIAT: CHAR(1) LOAD_DTTM: PSDATETIME LASTUPDDTTM: PSDATETIME ERROR_FLAG: CHAR(1) PS_BP_LINE_BUS_TBL BUSINESS_UNIT: CHAR(5) (FK) 1 BP_LINE_SEQ_NO: DECIMAL(15) BP_ADJUSTMENT_ID: CHAR(15) PS_BP_USRVIEW_CFS BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) OPRID: CHAR(30) (FK) BP_USRVIEW_NAME: CHAR(30) (FK) FIELD_SEQUENCE: SMALLINT CHARTFIELD: CHAR(18) BP_DIMENSION_LEVEL: CHAR(1) BP_SHOW_CF_CODE: CHAR(1) BP_SHOW_CF_DESCR: CHAR(1) FROM_VALUE: CHAR(30) TO_VALUE: CHAR(30) BP_BUDGET_CATEGORY: CHAR(15) PS_BP_USRVIEW_TBL BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) OPRID: CHAR(30) BP_USRVIEW_NAME: CHAR(30) DESCR50: CHAR(50) BP_PUBLIC_FLG: CHAR(1) BP_CASUAL_USR_FLG: CHAR(1) BP_ROW_SUMM_FLG: CHAR(1) BP_ROW_DTL_FLG: CHAR(1) BP_ROW_PRD_SUM_FLG: CHAR(1) BP_ROW_PRD_DTL_FLG: CHAR(1) BP_ENTRY_MTHD_FLG: CHAR(1) BP_ENTRY_ADJ_FLG: CHAR(1) BP_ENTRY_ALL_FLG: CHAR(1) BP_ENTRY_TOT_FLG: CHAR(1) BP_ENTRY_CURR_FLG: CHAR(1) BP_DSPL_STAT_FLG: CHAR(1) BP_DSPL_TGT_FLG: CHAR(1) BP_TGT_OPTN_FLG: CHAR(1) BP_TARGET_CURR: CHAR(3) PS_BP_USRVIEW_ANL BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) OPRID: CHAR(30) (FK) BP_USRVIEW_NAME: CHAR(30) (FK) BP_ANAL_BASE_ID: CHAR(1) SELECT_FLAG: CHAR(1)

    PS_BP_LINE_ADJ_CFS BUSINESS_UNIT: CHAR(5) (FK) BP_ADJUSTMENT_ID: CHAR(15) (FK) CHARTFIELD: CHAR(18) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) FROM_VALUE: CHAR(30) TO_VALUE: CHAR(30)

    PS_BP_LINE_ADJ_DTL BP_CHECKOUTID: CHAR(33) BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) (FK) BP_ADJUSTMENT_ID: CHAR(15) (FK) BP_ADJ_SEQ_NO: DECIMAL(15) BP_LINE_SEQ_NO: DECIMAL(15) BP_BUDG_CNTR_ADV: CHAR(30) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_ADJ_BUD_CTR: CHAR(31) BP_ADJ_AMT: DECIMAL(27,4) BP_ADJ_STATUS: CHAR(1)

    PS_BP_WRKLST_TBL BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_WL_STATUS: CHAR(1) SCENARIO: CHAR(10) BP_SUBMIT_VERSION: CHAR(1) BP_SUBMIT_DTTM: PSDATETIME BP_REJECT_DTTM: PSDATETIME

    PS_BP_WRKLST_VER BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_BUDGET_VERSION: CHAR(1) DESCR: CHAR(30) BP_WL_TOT_EXP: DECIMAL(26,3) BP_WL_TOT_REV: DECIMAL(26,3) BP_WL_TOT_OTHER: DECIMAL(26,3) CURRENCY_CD: CHAR(3) LASTUPDDTTM: PSDATETIME

    PS_BP_LINE_ADJ_HDR BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_ADJUSTMENT_ID: CHAR(15) BP_BUDGET_CATEGORY: CHAR(15) CURRENCY_CD: CHAR(3) BP_ADJ_STATUS: CHAR(1) BP_ADJ_PCT: DECIMAL(5,2) BP_ADJ_TOT_AMT: DECIMAL(27,4) BUDGET_PERIOD_FROM: CHAR(8) BUDGET_PERIOD_TO: CHAR(8) BP_ADJ_AMT_TOT: DECIMAL(27,4) BP_BEF_ADJ_AMT_TOT: DECIMAL(27,4) BP_AFT_ADJ_AMT_TOT: DECIMAL(27,4) DESCR254: CHAR(254) OPRID: CHAR(30) LASTUPDDTTM: PSDATETIME BP_STAT_BUDG_FLG: CHAR(1)

    PS_BP_TGT_TOLNCE SETID: CHAR(5) BP_TGT_TOL_ID: CHAR(15) EFFDT: PSDATE EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3)

    PS_BP_TGT_TOL_ACCT SETID: CHAR(5) (FK) BP_TGT_TOL_ID: CHAR(15) (FK) EFFDT: PSDATE (FK) FROM_ACCOUNT: CHAR(10) BP_TGT_TOL_TYPE: CHAR(1) TO_ACCOUNT: CHAR(10) BP_TGT_TOL_OP_CD: CHAR(1) BP_TGT_TOL_PCT: DECIMAL(13,5) BP_TGT_TOL_AMT: DECIMAL(26,3) CURRENCY_CD: CHAR(3)

    1, 1 / 1, 1 -- 1:28:20 PM , 9/3/2004

    POSITION BUDGETING -- Physical / <Main Subject Area>


    PS_BUS_UNIT_TBL_GL BUSINESS_UNIT: CHAR(5) AS_OF_DATE: PSDATE BASE_CURRENCY: CHAR(3) BUSINESS_UNIT_PF: CHAR(5) ELIMS_ONLY: CHAR(1) JRNL_BALANCE_OPTN: CHAR(1) JRNL_EDIT_ERR_OPTN: CHAR(1) JRNL_AMT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN: CHAR(1) JRNL_DT_ERR_OPTN2: CHAR(1) CONTROL_TOTAL_OPTN: CHAR(1) CURRENCY_BAL_OPTN: CHAR(1) BASE_CUR_ADJ_OPTN: CHAR(1) JRNL_FOREIGN_OPTN: CHAR(1) ENABLE_UNPOST_DT: CHAR(1) JRNL_APPRVL_OPTN: CHAR(1) STL_APPROVALS: CHAR(1) STL_APPROV_OPT: CHAR(1) BD_JRNL_APPR_OPTN: CHAR(1) BUSPROCNAME: CHAR(30) APPR_RULE_SET: CHAR(30) BUSPROCNAME_BD: CHAR(30) APPR_RULE_SET_BD: CHAR(30) TR_CONFIRM_SW: CHAR(1) TR_CONFO_MAIL_SW: CHAR(1) TR_PREAPPR_SW: CHAR(1) TR_RVL_RATE_INDEX: CHAR(10) TR_RVL_RT_TYPE: CHAR(5) TR_SCHD_POSN_CREAT: CHAR(1) TR_SCHD_RUN_CTL_ID: CHAR(30) TR_SCHD_RUNLOCN: CHAR(1) TR_SCHD_SERVERNAME: CHAR(8) TR_BX_APPL_JRNL_ID: CHAR(10) TR_CALENDAR_ID: CHAR(2) TRA_REVIEW_STATUS: CHAR(1) INT_ENTITYCD: CHAR(4) EXT_ENTITYCD: CHAR(4) PYMNT_METHOD: CHAR(3) DOC_SEQ: CHAR(1) DOC_TYPE: CHAR(8) VAT_CALC_TYPE: CHAR(1) VAT_TXN_TYPE_CD: CHAR(4) VAT_TOL_AMT: DECIMAL(26,3) VAT_TOL_CUR_CD: CHAR(3) VAT_TOL_PCT: DECIMAL(7,2) VAT_TOL_RT_TYPE: CHAR(5) TAX_CD_VAT: CHAR(8) VAT_USE_ID: CHAR(6) VAT_OVR_RCVRY_FLG: CHAR(1) VAT_NRCVR_PRO_FLG: CHAR(1) VAT_NRCVR_ALL_FLG: CHAR(1) VAT_APORT_CNTRL: CHAR(1) HOLIDAY_LIST_ID: CHAR(10) POST_DATE_OPTN: CHAR(1) PROCESS_DATE: PSDATE IU_INTER_TMPLT_CD: CHAR(5) IU_INTRA_TMPLT_CD: CHAR(5) IU_LEGAL_ENT_BU: CHAR(5) BUSINESS_UNIT_AP: CHAR(5) VENDOR_ID: CHAR(10) LOCATION: CHAR(10) BUSINESS_UNIT_BI: CHAR(5) CUST_ID: CHAR(15) OPERATING_UNIT: CHAR(8) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) CLASS_FLD: CHAR(5) PROGRAM_CODE: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) PROJECT_ID: CHAR(15) DEPTID: CHAR(10) CUST_VNDR_AFFILIAT: CHAR(1) LOAD_DTTM: PSDATETIME LASTUPDDTTM: PSDATETIME ERROR_FLAG: CHAR(1) PS_BP_POS_ACCT BUSINESS_UNIT: CHAR(5) FROM_ACCOUNT: CHAR(10) ACCT_POS_TYPE: CHAR(1) TO_ACCOUNT: CHAR(10) PS_BP_POS_BUDG_ACT BUSINESS_UNIT: CHAR(5) (FK) FROM_ACCOUNT: CHAR(10) (FK) BP_POS_BUDG: CHAR(1) TO_ACCOUNT: CHAR(10) PS_BP_HRMS_INSTALL BP_POS_PREFIX: CHAR(3) BP_POS_NBR_LAST: INT PS_BP_ADJST_FLAG ADJUST_FLAG: CHAR(1)

    PS_BP_HR_SECURITY BUSINESS_UNIT: CHAR(5) (FK) HR_POS_CONTROL: CHAR(10) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDG_CNTR_ADV: CHAR(30) 1

    PS_BP_JOB_DEFAULT SETID: CHAR(5) (FK) EFFDT: PSDATE (FK) JOBCODE: CHAR(6) EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3) SAL_GRP_ID: CHAR(15) BNFT_GRP_ID: CHAR(15) EARN_GRP_ID: CHAR(15) BP_TAX_GRP_ID: CHAR(15) DISTR_PROFL_ID: CHAR(10) UNION_CD: CHAR(3) PS_BP_JOB_DEFLT_HD SETID: CHAR(5) EFFDT: PSDATE EFF_STATUS: CHAR(1)

    PS_BP_HRMS_DEFAULT BUSINESS_UNIT: CHAR(5) (FK) STD_HOURS: DECIMAL(6,2) BP_STD_DAYS: SMALLINT BP_STD_WEEKS: SMALLINT BP_DEFAULT_DISTR: CHAR(10) BP_MEDICARE_TAX: DECIMAL(5,3) BP_OTH_TAX: DECIMAL(5,3) BP_DFLT_BUDG_FCT: DECIMAL(7,6) DFLT_EARN_ACCT: CHAR(10) DFLT_BNFT_ACCT: CHAR(10) DFLT_SAL_ACCT: CHAR(10) DFLT_TAX_ACCT: CHAR(10) DFLT_MED_TAX_ACCT: CHAR(10) DFLT_OTH_TAX_ACCT: CHAR(10) MED_TAX_PLANTYPE: CHAR(4) OTH_TAX_PLANTYPE: CHAR(4) MAP_STATUS: CHAR(1) VALID_STATUS: CHAR(1) BP_RATE_COMBO_ID: CHAR(10)

    PS_BP_BNFT_ADJST BP_CHECKOUTID: CHAR(33) OPRID: CHAR(30) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT POSITION_NBR: CHAR(8) SELECTED_FLAG: CHAR(1) EFFDT: PSDATE BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_CALC_AMOUNT: DECIMAL(27,4) BP_MANUAL_AMT: DECIMAL(12,2) AFTER_ADJ: DECIMAL(12,2) AMOUNT_SIGN: SMALLINT PERCENT_SIGN: SMALLINT

    PS_BP_SAL_ADJST BP_CHECKOUTID: CHAR(33) OPRID: CHAR(30) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT POSITION_NBR: CHAR(8) SELECTED_FLAG: CHAR(1) EFFDT: PSDATE BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_CALC_AMOUNT: DECIMAL(27,4) BP_MANUAL_AMT: DECIMAL(12,2) AFTER_ADJ: DECIMAL(12,2) PERCENT_SIGN: SMALLINT AMOUNT_SIGN: SMALLINT

    PS_BP_SAL_STEP SETID: CHAR(5) (FK) SAL_ADMIN_PLAN: CHAR(4) (FK) GRADE: CHAR(3) (FK) EFFDT: PSDATE (FK) STEP: SMALLINT CURRENCY_CD: CHAR(3) HOURLY_RT: DECIMAL(18,6) MONTHLY_RT: DECIMAL(21,6) ANNUAL_RT: DECIMAL(21,6) INCREM_MONTHS: INT INCREM_HOURS: DECIMAL(9,2) DAILY_RT: DECIMAL(18,3) GVT_BIWEEKLY_RT: DECIMAL(9,2) GVT_INCREM_DAYS: SMALLINT GVT_INCREM_WEEKS: SMALLINT GVT_STEP: CHAR(2)

    PS_BP_SAL_GRADE SETID: CHAR(5) (FK) SAL_ADMIN_PLAN: CHAR(4) (FK) GRADE: CHAR(3) EFFDT: PSDATE (FK) EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) CURRENCY_CD: CHAR(3) MIN_RT_HOURLY: DECIMAL(18,6) MID_RT_HOURLY: DECIMAL(18,6) MAX_RT_HOURLY: DECIMAL(18,6) MIN_RT_MONTHLY: DECIMAL(18,3) MID_RT_MONTHLY: DECIMAL(18,3) MAX_RT_MONTHLY: DECIMAL(18,3) MIN_RT_ANNUAL: DECIMAL(18,3) MID_RT_ANNUAL: DECIMAL(18,3) MAX_RT_ANNUAL: DECIMAL(18,3) MIN_RT_DAILY: DECIMAL(18,3) MID_RT_DAILY: DECIMAL(18,3) MAX_RT_DAILY: DECIMAL(18,3) GVT_MAX_RT_BIWK: DECIMAL(9,2) GVT_MID_RT_BIWK: DECIMAL(9,2) GVT_MIN_RT_BIWK: DECIMAL(9,2)

    PS_BP_ACTN_REASON ACTION: CHAR(3) ACTION_REASON: CHAR(3) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10)

    PS_BP_PLAN_TYPE PLAN_TYPE: CHAR(2) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10)

    PS_BP_POS_OWN_TBL BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_PLANNING_ID: CHAR(15) BP_BUDG_CNTR_ADV: CHAR(30) BP_EXCLUDE: CHAR(1)

    PS_BP_BARG_TBL BP_BARG_ID: CHAR(10) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10)

    PS_BP_EARN_ADJST BP_CHECKOUTID: CHAR(33) OPRID: CHAR(30) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT POSITION_NBR: CHAR(8) PS_BP_SAL_PLAN SETID: CHAR(5) SAL_ADMIN_PLAN: CHAR(4) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) STD_HOURS: DECIMAL(6,2) CURRENCY_CD: CHAR(3) SELECTED_FLAG: CHAR(1) EFFDT: PSDATE BP_PERCENTAGE: DECIMAL(7,2) AMOUNT: DECIMAL(26,3) BP_CALC_AMOUNT: DECIMAL(27,4) BP_MANUAL_AMT: DECIMAL(12,2) AFTER_ADJ: DECIMAL(12,2) AMOUNT_SIGN: SMALLINT PERCENT_SIGN: SMALLINT

    PS_BP_BNFT_GRP_DVW SETID: CHAR(5) (FK) BNFT_GRP_ID: CHAR(15) (FK) EFFDT: PSDATE EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3)

    PS_BP_BNFT_GRP_DTL SETID: CHAR(5) (FK) BNFT_GRP_ID: CHAR(15) (FK) PLAN_TYPE: CHAR(2) EFFDT: PSDATE (FK) ACCOUNT: CHAR(10) FLAT_AMOUNT: DECIMAL(25,2) PCT_OF_SALARY: DECIMAL(5,2) ACC_OVRD_FLG: CHAR(3) SAL_OVRD_FLG: CHAR(3)

    PS_BP_SAL_GRP_DTL SETID: CHAR(5) (FK) SAL_GRP_ID: CHAR(15) (FK) EFFDT: PSDATE PS_BP_SAL_GRP_TBL SETID: CHAR(5) SAL_GRP_ID: CHAR(15) DESCR: CHAR(30) EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3) SALARY_PLAN: CHAR(12) GRADE: CHAR(3) STEP: SMALLINT ACCOUNT: CHAR(10) SURVEY_SALARY: INT ACC_OVRD_FLG: CHAR(3) SAL_OVRD_FLG: CHAR(3)

    PS_BP_JOB EMPLID: CHAR(11) EMPL_RCD: SMALLINT EFFDT: PSDATE EFFSEQ: SMALLINT JOBCODE: CHAR(6) POSITION_NBR: CHAR(8) POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) DEPTID: CHAR(10) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) LOCATION: CHAR(10) TAX_LOCATION_CD: CHAR(10) JOB_ENTRY_DT: PSDATE DEPT_ENTRY_DT: PSDATE POSITION_ENTRY_DT: PSDATE SHIFT: CHAR(1) REG_TEMP: CHAR(1) FULL_PART_TIME: CHAR(1) COMPANY: CHAR(3) PAYGROUP: CHAR(3) BAS_GROUP_ID: CHAR(3) ELIG_CONFIG1: CHAR(10) ELIG_CONFIG2: CHAR(10) ELIG_CONFIG3: CHAR(10) ELIG_CONFIG4: CHAR(10) ELIG_CONFIG5: CHAR(10) ELIG_CONFIG6: CHAR(10) ELIG_CONFIG7: CHAR(10) ELIG_CONFIG8: CHAR(10) ELIG_CONFIG9: CHAR(10) BEN_STATUS: CHAR(4) BAS_ACTION: CHAR(3) COBRA_ACTION: CHAR(3) EMPL_TYPE: CHAR(1) HOLIDAY_SCHEDULE: CHAR(6) STD_HOURS: DECIMAL(6,2) STD_HRS_FREQUENCY: CHAR(5) OFFICER_CD: CHAR(1) EMPL_CLASS: CHAR(3) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) GRADE_ENTRY_DT: PSDATE STEP: SMALLINT STEP_ENTRY_DT: PSDATE GL_PAY_TYPE: CHAR(6) ACCT_CD: CHAR(25) EARNS_DIST_TYPE: CHAR(1) SALARY_MATRIX_CD: CHAR(5) RATING_SCALE: CHAR(4) REVIEW_RATING: CHAR(1) REVIEW_DT: PSDATE COMP_FREQUENCY: CHAR(5) COMPRATE: DECIMAL(18,6) CHANGE_AMT: DECIMAL(18,6) CHANGE_PCT: DECIMAL(6,3) ANNUAL_RT: DECIMAL(21,6) MONTHLY_RT: DECIMAL(21,6) DAILY_RT: DECIMAL(18,3) HOURLY_RT: DECIMAL(18,6) ANNL_BENEF_BASE_RT: DECIMAL(21,6) SHIFT_RT: DECIMAL(18,6) SHIFT_FACTOR: DECIMAL(4,3) CURRENCY_CD: CHAR(3) BUSINESS_UNIT: CHAR(5) SETID_DEPT: CHAR(5) SETID_JOBCODE: CHAR(5) SETID_LOCATION: CHAR(5) SETID_SALARY: CHAR(5) REG_REGION: CHAR(5) DIRECTLY_TIPPED: CHAR(1) FLSA_STATUS: CHAR(1) EEO_CLASS: CHAR(1) FUNCTION_CD: CHAR(2) TARIFF_GER: CHAR(2) TARIFF_AREA_GER: CHAR(3) PERFORM_GROUP_GER: CHAR(2) LABOR_TYPE_GER: CHAR(1) SPK_COMM_ID_GER: CHAR(9) HOURLY_RT_FRA: CHAR(3) ACCDNT_CD_FRA: CHAR(1) VALUE_1_FRA: CHAR(5) VALUE_2_FRA: CHAR(5) VALUE_3_FRA: CHAR(5) VALUE_4_FRA: CHAR(5) VALUE_5_FRA: CHAR(5) CTG_RATE: SMALLINT PAID_HOURS: DECIMAL(6,2) PAID_FTE: DECIMAL(3,2) PAID_HRS_FREQUENCY: CHAR(5) GVT_EFFDT: PSDATE GVT_EFFDT_PROPOSED: PSDATE GVT_TRANS_NBR: SMALLINT GVT_TRANS_NBR_SEQ: SMALLINT GVT_WIP_STATUS: CHAR(3) GVT_STATUS_TYPE: CHAR(3) GVT_NOA_CODE: CHAR(3) GVT_LEG_AUTH_1: CHAR(3) GVT_PAR_AUTH_D1: CHAR(25) GVT_PAR_AUTH_D1_2: CHAR(25) GVT_LEG_AUTH_2: CHAR(3) GVT_PAR_AUTH_D2: CHAR(25) GVT_PAR_AUTH_D2_2: CHAR(25) GVT_PAR_NTE_DATE: PSDATE GVT_WORK_SCHED: CHAR(1) GVT_SUB_AGENCY: CHAR(2) GVT_ELIG_FEHB: CHAR(3) GVT_FEHB_DT: PSDATE GVT_PAY_RATE_DETER: CHAR(1) GVT_STEP: CHAR(2) GVT_RTND_PAY_PLAN: CHAR(2) GVT_RTND_SAL_PLAN: CHAR(4) GVT_RTND_GRADE: CHAR(3) GVT_RTND_STEP: SMALLINT GVT_RTND_GVT_STEP: CHAR(2) GVT_PAY_BASIS: CHAR(2) GVT_COMPRATE: DECIMAL(18,6) GVT_LOCALITY_ADJ: DECIMAL(7,2) GVT_BIWEEKLY_RT: DECIMAL(9,2) GVT_DAILY_RT: DECIMAL(9,2) GVT_HRLY_RT_NO_LOC: DECIMAL(18,6) GVT_DLY_RT_NO_LOC: DECIMAL(9,2) GVT_BW_RT_NO_LOC: DECIMAL(9,2) GVT_MNLY_RT_NO_LOC: DECIMAL(18,3) GVT_ANNL_RT_NO_LOC: DECIMAL(18,3) GVT_XFER_FROM_AGCY: CHAR(2) GVT_XFER_TO_AGCY: CHAR(2) GVT_RETIRE_PLAN: CHAR(1) GVT_ANN_IND: CHAR(1) GVT_FEGLI: CHAR(2) GVT_FEGLI_LIVING: CHAR(1) GVT_LIVING_AMT: INT GVT_ANNUITY_OFFSET: INT GVT_CSRS_FROZN_SVC: CHAR(4) GVT_PREV_RET_COVRG: CHAR(1) GVT_FERS_COVERAGE: CHAR(1) GVT_TYPE_OF_APPT: CHAR(2) GVT_POI: CHAR(4) GVT_POSN_OCCUPIED: CHAR(1) GVT_CONT_EMPLID: CHAR(11) GVT_ROUTE_NEXT: CHAR(11) GVT_CHANGE_FLAG: CHAR(1) GVT_TSP_UPD_IND: CHAR(1) GVT_PI_UPD_IND: CHAR(1) GVT_SF52_NBR: CHAR(10) GVT_S113G_CEILING: CHAR(1) GVT_LEO_POSITION: CHAR(1) GVT_ANNUIT_COM_DT: PSDATE GVT_BASIC_LIFE_RED: CHAR(2) GVT_DED_PRORT_DT: PSDATE GVT_FEGLI_BASC_PCT: DECIMAL(7,6) GVT_FEGLI_OPT_PCT: DECIMAL(7,6) GVT_FEHB_PCT: DECIMAL(7,6) GVT_RETRO_FLAG: CHAR(1) GVT_RETRO_DED_FLAG: CHAR(1) GVT_RETRO_JOB_FLAG: CHAR(1) GVT_RETRO_BSE_FLAG: CHAR(1) GVT_OTH_PAY_CHG: CHAR(1) GVT_DETL_POSN_NBR: CHAR(8) ANNL_BEN_BASE_OVRD: CHAR(1) BENEFIT_PROGRAM: CHAR(3) UPDATE_PAYROLL: CHAR(1) GVT_PAY_PLAN: CHAR(2) GVT_PAY_FLAG: CHAR(1) GVT_NID_CHANGE: CHAR(1) UNION_FULL_PART: CHAR(1) UNION_POS: CHAR(1) MATRICULA_NBR: SMALLINT SOC_SEC_RISK_CODE: CHAR(3) UNION_FEE_AMOUNT: DECIMAL(8,2) UNION_FEE_START_DT: PSDATE UNION_FEE_END_DT: PSDATE EXEMPT_JOB_LBR: CHAR(1) EXEMPT_HOURS_MONTH: SMALLINT WRKS_CNCL_FUNCTION: CHAR(1) INTERCTR_WRKS_CNCL: CHAR(1) CURRENCY_CD1: CHAR(3) PAY_UNION_FEE: CHAR(1) UNION_CD: CHAR(3) BARG_UNIT: CHAR(4) UNION_SENIORITY_DT: PSDATE ENTRY_DATE: PSDATE LABOR_AGREEMENT: CHAR(6) EMPL_CTG: CHAR(6) EMPL_CTG_L1: CHAR(6) EMPL_CTG_L2: CHAR(6) SETID_LBR_AGRMNT: CHAR(5) GP_PAYGROUP: CHAR(10) GP_DFLT_ELIG_GRP: CHAR(1) GP_ELIG_GRP: CHAR(10) GP_DFLT_CURRTTYP: CHAR(1) CUR_RT_TYPE: CHAR(5) GP_DFLT_EXRTDT: CHAR(1) GP_ASOF_DT_EXG_RT: CHAR(1) ADDS_TO_FTE_ACTUAL: CHAR(1) CLASS_INDC: CHAR(1) ENCUMB_OVERRIDE: CHAR(1) FICA_STATUS_EE: CHAR(1) FTE: DECIMAL(9,6) PRORATE_CNT_AMT: CHAR(1) PAY_SYSTEM_FLG: CHAR(2) BORDER_WALKER: CHAR(1) LUMP_SUM_PAY: CHAR(1) CONTRACT_NUM: CHAR(25) JOB_INDICATOR: CHAR(1) WRKS_CNCL_ROLE_CHE: CHAR(30) WRKS_CNCL_ID_LCL: CHAR(9) BENEFIT_SYSTEM: CHAR(2) WORK_DAY_HOURS: DECIMAL(6,2) SUPERVISOR_ID: CHAR(11) REPORTS_TO: CHAR(8) FORCE_PUBLISH: PSDATE JOB_DATA_SRC_CD: CHAR(3) ESTABID: CHAR(12) LOAD_DTTM: PSDATETIME LASTUPDDTTM: PSDATETIME ERROR_FLAG: CHAR(1)

    PS_BP_BNFT_GRP_TBL SETID: CHAR(5) BNFT_GRP_ID: CHAR(15) DESCR: CHAR(30)

    PS_BP_EARN_GRP_DTL SETID: CHAR(5) (FK) EARN_GRP_ID: CHAR(15) (FK) EARNING_CD: CHAR(25) EFFDT: PSDATE (FK) ACCOUNT: CHAR(10) PCT_OF_SALARY: DECIMAL(5,2) FLAT_AMOUNT: DECIMAL(25,2) ACC_OVRD_FLG: CHAR(3) SAL_OVRD_FLG: CHAR(3)

    PS_BP_TAX_GRP_DVW SETID: CHAR(5) (FK) BP_TAX_GRP_ID: CHAR(15) (FK) EFFDT: PSDATE EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3)

    PS_BP_TAX_GRP_TBL SETID: CHAR(5) BP_TAX_GRP_ID: CHAR(15) DESCR: CHAR(30)

    PS_BP_EARN_GRP_TBL SETID: CHAR(5) EARN_GRP_ID: CHAR(15) DESCR: CHAR(30)

    PS_BP_EARN_GRP_DVW SETID: CHAR(5) (FK) EARN_GRP_ID: CHAR(15) (FK) EFFDT: PSDATE EFF_STATUS: CHAR(1) CURRENCY_CD: CHAR(3)

    PS_BP_TAX_GRP_DTL SETID: CHAR(5) (FK) BP_TAX_GRP_ID: CHAR(15) (FK) TAX_CLASS: CHAR(1) EFFDT: PSDATE (FK) ACCOUNT: CHAR(10) FLAT_AMOUNT: DECIMAL(25,2) BP_MAX_GROSS: INT PCT_OF_SALARY: DECIMAL(5,2) ACC_OVRD_FLG: CHAR(3) SAL_OVRD_FLG: CHAR(3)

    PS_BP_DISTR_PF_DTL SETID: CHAR(5) (FK) DISTR_PROFL_ID: CHAR(10) (FK) EFFDT: PSDATE (FK) SEQUENCE_NBR: SMALLINT PERCENTAGE: DECIMAL(5,2) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5)

    PS_BP_DISTR_PRFL SETID: CHAR(5) DISTR_PROFL_ID: CHAR(10)

    PS_BP_DISTR_PF_DVW SETID: CHAR(5) (FK) DISTR_PROFL_ID: CHAR(10) (FK) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) SALARY_DISTR: CHAR(1) BENEFIT_DISTR: CHAR(1) EARNING_DISTR: CHAR(1) BP_TAX_DISTR: CHAR(1)

    PS_BP_BNFT_DIS_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) PLAN_TYPE: CHAR(2) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE (FK) EFFSEQ: SMALLINT (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_BNFT_PERCENT: DECIMAL(5,2) BP_BNFT_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_SAL_DIS_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) EFFDT: PSDATE (FK) EFFSEQ: SMALLINT (FK) DISTR_SEQ_NBR: SMALLINT BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) TOTAL_SALARY: DECIMAL(26,3) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_EARN_DIS_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) BP_EARN_CD: CHAR(3) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE (FK) EFFSEQ: SMALLINT (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_EARN_PERCENT: DECIMAL(5,2) BP_EARN_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) ADD_GROSS: CHAR(1) BP_ONETIMEPAY: CHAR(1) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_JOB_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) EMPL_RCD_NUM: SMALLINT EFFDT: PSDATE (FK) EFFSEQ: SMALLINT BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) POSITION_OVERRIDE: CHAR(1) POSN_CHANGE_RECORD: CHAR(1) EMPL_STATUS: CHAR(1) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) JOBCODE: CHAR(6) FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) UNION_CD: CHAR(3) ORIGNL_CURRENCY_CD: CHAR(3) BP_BARG_ID: CHAR(10) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FICA_STATUS_EE: CHAR(1) CURRENCY_CD: CHAR(3) BP_TOTAL_SALARY: DECIMAL(26,3) BP_TOTAL_EARNING: DECIMAL(26,3) BP_ALLOWANCE: DECIMAL(26,3) BP_ONE_TIME_PAY: DECIMAL(26,3) BP_TOTAL_BNFT: DECIMAL(26,3) BP_TOTAL_TAX: DECIMAL(26,3) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) HR_POS_CONTROL: CHAR(10) LOCATION: CHAR(10)

    PS_BP_TAX_DIS_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EMPLID: CHAR(11) (FK) EMPL_RCD_NUM: SMALLINT (FK) TAX_CLASS: CHAR(1) DISTR_SEQ_NBR: SMALLINT EFFDT: PSDATE (FK) EFFSEQ: SMALLINT (FK) BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) ACCOUNT: CHAR(10) ALTACCT: CHAR(10) CURRENCY_CD: CHAR(3) STATISTICS_CODE: CHAR(3) PROJECT_ID: CHAR(15) BUDGET_PERIOD: CHAR(8) OPERATING_UNIT: CHAR(8) DEPTID: CHAR(10) PRODUCT: CHAR(6) FUND_CODE: CHAR(5) PROGRAM_CODE: CHAR(5) CLASS_FLD: CHAR(5) BUDGET_REF: CHAR(8) AFFILIATE: CHAR(5) AFFILIATE_INTRA1: CHAR(10) AFFILIATE_INTRA2: CHAR(10) CHARTFIELD1: CHAR(10) CHARTFIELD2: CHAR(10) CHARTFIELD3: CHAR(10) BUSINESS_UNIT_PC: CHAR(5) ACTIVITY_ID: CHAR(15) RESOURCE_TYPE: CHAR(5) ANALYSIS_TYPE: CHAR(3) RESOURCE_CATEGORY: CHAR(5) RESOURCE_SUB_CAT: CHAR(5) BP_MAX_GROSS: INT BP_TAX_PERCENT: DECIMAL(5,2) BP_TAX_AMOUNT: DECIMAL(26,3) PERCENTAGE: DECIMAL(5,2) AMOUNT: DECIMAL(26,3) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30)

    PS_BP_POSITION_TBL BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) (FK) POSITION_NBR: CHAR(8) (FK) EFFDT: PSDATE BP_BUDGET_CENTER1: CHAR(15) (FK) BP_BUDGET_CENTER2: CHAR(15) (FK) EFF_STATUS: CHAR(1) DESCR: CHAR(30) DESCRSHORT: CHAR(10) ACTION: CHAR(3) ACTION_DT: PSDATE ACTION_REASON: CHAR(3) HR_POS_CONTROL: CHAR(10) JOBCODE: CHAR(6) SAL_ADMIN_PLAN: CHAR(4) GRADE: CHAR(3) STEP: SMALLINT FULL_PART_TIME: CHAR(1) REG_TEMP: CHAR(1) MAX_HEAD_COUNT: SMALLINT UNION_CD: CHAR(3) BP_EXCLUDE: CHAR(1) STD_HOURS: DECIMAL(6,2) FTE: DECIMAL(9,6) BP_BUDG_FACTOR: DECIMAL(4,2) UPDATE_INCUMBENTS: CHAR(1) BP_FROM_INTRFC: CHAR(1) BP_BUDGET_VERSION: CHAR(1) BP_LEDGER_NAME: CHAR(30) BP_BUDG_CNTR_ADV: CHAR(30) POSN_STATUS: CHAR(1) BUSINESS_UNIT_HR: CHAR(5) BP_BUDG_IMPACT: DECIMAL(31,3) BP_POS_STATUS: CHAR(1)

    PS_BP_ADV_CHECKOUT BP_CHECKOUTID: CHAR(33) BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_LEDGER_NAME: CHAR(30) BP_BUDGET_VERSION: CHAR(1) BP_BUDGET_VER_ID: CHAR(1) BP_ADV_ROLENAME: CHAR(80) SCENARIO: CHAR(10) OPRID: CHAR(30) TRANSACTION_ID: CHAR(10) READ_ONLY_FLAG: CHAR(1) BP_CHECKOUT_DT: PSDATETIME TYPE: CHAR(1) BAM_MODEL_ID: CHAR(20)

    PS_BP_POS_OWNER BP_CHECKOUTID: CHAR(33) (FK) BUSINESS_UNIT: CHAR(5) POSITION_NBR: CHAR(8) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_BUDG_CNTR_ADV: CHAR(30) BP_EXCLUDE: CHAR(1)

    1, 1 / 1, 1 -- 1:29:05 PM , 9/3/2004

    SETUP -- Physical / <Main Subject Area>


    PS_BP_CURR_OPTION BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) CURRENCY_CD: CHAR(3) BP_ENTRY_CURRENCY: CHAR(1) BP_ENTRY_DEFAULT: CHAR(1) BP_TARGET_CURRENCY: CHAR(1) PS_BP_PLAN_MODEL BUSINESS_UNIT: CHAR(5) BP_PLANNING_ID: CHAR(15) BP_MODEL_DATE: PSDATE LEDGER_TYPE_ID: CHAR(30) METHOD_GROUP_ID: CHAR(4) BP_BUDGET_CATEGORY: CHAR(15) START_DT: PSDATE END_DT: PSDATE MULTICURRENCY: CHAR(1) BP_RATE_COMBO_ID: CHAR(10) TEMPLATE_ID: CHAR(15) KK_USE_RULESETS: CHAR(1) DESCRLONG: TEXT PS_BP_PLAN_ACCT BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) FROM_ACCOUNT: CHAR(10) BP_CHARTFIELD_FROM: CHAR(40) TO_ACCOUNT: CHAR(10) BP_CHARTFIELD_TO: CHAR(40) METHOD_ID: CHAR(10) BP_DRIVER_ID: CHAR(20) BP_ANAL_BASE_ID: CHAR(1) BP_OVERRIDE_MTHD: CHAR(1) BP_OVERRIDE_BASE: CHAR(1) BP_OVERRIDE_DRVR: CHAR(1) BP_OVERRIDE_DPARAM: CHAR(1) BP_HOLD_FLAG: CHAR(1) BP_ADJUST_FLAG: CHAR(1) CHARTFIELD: CHAR(18) PS_BP_LEDG_TYP_VAL SETID: CHAR(5) LEDGER_TYPE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) PF_LED_ID: CHAR(10) LEDGER: CHAR(10) FISCAL_YEAR: SMALLINT FISCAL_YEAR2: SMALLINT SCENARIO: CHAR(10) BP_FORECAST_TYPE: CHAR(1) CALENDAR_TYPE: CHAR(1) CALENDAR_ID: CHAR(2) BUDGET_PERIOD_FROM: CHAR(8) BUDGET_PERIOD_TO: CHAR(8) DEFAULT_LEDGER: CHAR(1) BP_LEDGER_NAME_2: CHAR(30) BP_SUM_CAL_ID: CHAR(2) BP_KK_TRANS_TYPE: CHAR(1) PS_BP_LEDG_TYP_ANL SETID: CHAR(5) LEDGER_TYPE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_ANAL_BASE_ID: CHAR(1) BP_LEDGER_NAME_2: CHAR(30)

    PS_BP_DIM_SELECT BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) CHARTFIELD: CHAR(18) DIMENSION_ID: CHAR(30) PS_BP_DIM_SUM BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) CHARTFIELD: CHAR(18)

    PS_BP_LEDGER_TYPE SETID: CHAR(5) LEDGER_TYPE_ID: CHAR(30) DESCR: CHAR(30) LEDGER_TEMPLATE: CHAR(10) BP_LEDGER_TYPE: CHAR(1)

    PS_BP_MDL_EM_TMPL BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_EM_TMPL_OPTN: CHAR(1) TEMPLATE_ID: CHAR(15) BP_EMAIL_FLG: CHAR(1)

    PS_BP_PHASE_BC BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15)

    PS_BP_CF_VAL_KK BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) SUBTYPE: CHAR(10) CHARTFIELD: CHAR(18) CF_VALUE: CHAR(30) BUDGET_PHASE_ID: CHAR(30) (FK)

    PS_BP_CF_VAL BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) CHARTFIELD: CHAR(18) CF_VALUE: CHAR(30) BUDGET_PHASE_ID: CHAR(30) (FK) DESCR: CHAR(30)

    PS_BP_PLAN_TGT_DEF BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_TGT_CNTL_GRP_ID: CHAR(15) BUDGET_PHASE_ID: CHAR(30) (FK)

    PS_BP_PHASES BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) START_DT: PSDATE END_DT: PSDATE TREE_LEVEL: CHAR(10) HOLD_PHASE: CHAR(1) BP_PLAN_MDL_STATUS: CHAR(1) BAM_MODEL_ID: CHAR(20) PROCESS_INSTANCE: DECIMAL(10)

    PS_BP_PHASE_LEVELS BUSINESS_UNIT: CHAR(5) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_PLANNING_ID: CHAR(15) (FK) TREE_LEVEL: CHAR(10) ROLENAME: CHAR(30) BP_DETAIL_VIEW: CHAR(1) PS_BP_PHASE_LEDGER BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) ALLOW_UPDATE_FLG: CHAR(1) FIRST_PERIOD_UPDT: CHAR(8) ACCOUNTING_PERIOD: SMALLINT ENFORCE_BUDGET: CHAR(1) BASE_BUDGET: CHAR(30) BUDGET_FACTOR: DECIMAL(5,2) ZBB: CHAR(1) BP_ASSET_CHK: CHAR(1) BP_POS_CHK: CHAR(1)

    PS_BP_PHASE_USERS BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_BUDGET_CENTER1: CHAR(15) BP_BUDGET_CENTER2: CHAR(15) BP_OPRID: CHAR(30) ROLENAME: CHAR(30)

    PS_BP_RATE_TBL BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_ANAL_BASE_ID: CHAR(1) ACCOUNT_TYPE: CHAR(1) BUDGET_PERIOD: CHAR(8) FROM_CUR: CHAR(3) TO_CUR: CHAR(3) RATE_MULT: DECIMAL(15,8) RATE_DIV: DECIMAL(15,8)

    PS_BP_BUDG_MAP_HD BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_LEDGER_NAME_TO: CHAR(30)

    PS_BP_BUDGET_MAP BUSINESS_UNIT: CHAR(5) (FK) BP_PLANNING_ID: CHAR(15) (FK) BUDGET_PHASE_ID: CHAR(30) (FK) BP_LEDGER_NAME: CHAR(30) (FK) BP_LEDGER_NAME_TO: CHAR(30) (FK) CHARTFIELD: CHAR(18) BP_CF_VALUE_FROM: CHAR(15) BP_CF_VALUE_FROM2: CHAR(15) BP_FISCAL_YR_FROM: SMALLINT BP_ACCT_PD_FROM: SMALLINT BP_BUDGET_PD_FROM: CHAR(8) BP_CF_VALUE_TO: CHAR(15) BP_FISCAL_YR_TO: SMALLINT BP_ACCT_PD_TO: SMALLINT BP_BUDGET_PD_TO: CHAR(8) BP_FACTOR_MULT: DECIMAL(7,4) TRANSLATE_TYPE: CHAR(1)

    PS_BP_MTHD_DRV_PER SETID: CHAR(5) METHOD_GROUP_ID: CHAR(4) (FK) EFFDT: PSDATE METHOD_ID: CHAR(10) (FK) BP_DRIVER_ID: CHAR(20) (FK) FISCAL_YEAR: SMALLINT (FK) ACCOUNTING_PERIOD: SMALLINT BP_DISTR_ID: CHAR(10) (FK) BP_DRIVER_PARM: DECIMAL(31,8) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME

    PS_BP_MTHD_DRV_GRP SETID: CHAR(5) METHOD_GROUP_ID: CHAR(4) (FK) EFFDT: PSDATE METHOD_ID: CHAR(10) BP_DRIVER_ID: CHAR(20) (FK) FISCAL_YEAR: SMALLINT BP_DISTR_ID: CHAR(10) (FK) CALENDAR_ID: CHAR(2) EFF_STATUS: CHAR(1) CODE_OR_ACCT: CHAR(1) ACCOUNT: CHAR(10) STATISTICS_CODE: CHAR(3) UNIT_DRIVER_ID: CHAR(20) AMOUNT_DRIVER_ID: CHAR(20) BP_PERCENT_AMT_ID: CHAR(1) BP_PERCENT_AMT_VAL: DECIMAL(31,8) BP_SUM_OR_AVG_ID: CHAR(1) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME CURRENCY_CD: CHAR(3)

    PS_BP_DIST_TYP BP_DISTR_ID: CHAR(10) EFFDT: PSDATE EFF_STATUS: CHAR(1) BP_DISTR_TYPE: CHAR(2) DESCR: CHAR(30) DESCRSHORT: CHAR(10) BP_MTHD_STAT_DRVR: CHAR(1) CURRENCY_CD: CHAR(3) CALENDAR_ID: CHAR(2) SETID1: CHAR(5) SETID2: CHAR(5) OPRID_APPROVED_BY: CHAR(30) APPROVAL_DTTM: PSDATETIME OPRID_ENTERED_BY: CHAR(30) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME DESCRLONG: TEXT

    PS_BP_DIST_ATTACHM BP_DISTR_ID: CHAR(10) (FK) EFFDT: PSDATE FISCAL_YEAR: SMALLINT DESCR: CHAR(30) ATTACHSYSFILENAME: CHAR(128) ATTACHUSERFILE: CHAR(64) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME PS_BP_DIST_DRV_BC BP_DISTR_ID: CHAR(10) (FK) EFFDT: PSDATE BP_BUDGET_CENTER1: CHAR(15) FISCAL_YEAR: SMALLINT SELECT_FLAG: CHAR(1) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME

    PS_BP_MTHD_DRV BP_DRIVER_ID: CHAR(20) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCRSHORT: CHAR(10) DESCR: CHAR(30) BP_MTHD_STAT_DRVR: CHAR(1) PS_BP_MTHD_GRP SETID: CHAR(5) METHOD_GROUP_ID: CHAR(4) EFFDT: PSDATE EFF_STATUS: CHAR(1) SETID1: CHAR(5) CURRENCY_CD: CHAR(3) OPRID_APPROVED_BY: CHAR(30) APPROVAL_DTTM: PSDATETIME OPRID_ENTERED_BY: CHAR(30) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME PS_BP_MTHD METHOD_ID: CHAR(10) BP_METHOD_NAME: CHAR(15) DESCR254: CHAR(254) DELIVERED: CHAR(1) DRVR_REQ: CHAR(1) ADD_DRVR: CHAR(1) BASE_REQUIRED: CHAR(1) TIME_FREQUENCY: CHAR(4) BP_DISPLAY_SEQ: SMALLINT PS_BP_DIST_DRV_PER BP_DISTR_ID: CHAR(10) (FK) EFFDT: PSDATE BP_BUDGET_CENTER1: CHAR(15) (FK) ACCOUNTING_PERIOD: SMALLINT FISCAL_YEAR: SMALLINT BP_DRIVER_PARM: DECIMAL(31,8) OPRID_LAST_UPDT: CHAR(30) LAST_DTTM_UPDATE: PSDATETIME

    PS_BP_MTHD_GRP_DT SETID: CHAR(5) METHOD_GROUP_ID: CHAR(4) (FK) EFFDT: PSDATE METHOD_ID: CHAR(10) (FK) EFF_STATUS: CHAR(1) SELECT_FLAG: CHAR(1) SETID1: CHAR(5)

    PS_BP_DIMENSION DIMENSION_ID: CHAR(30) DESCR: CHAR(30) CHARTFIELD: CHAR(18)

    PS_BP_BU_DIMENSION SETID: CHAR(5) DIMENSION_ID: CHAR(30) (FK) EFFDT: PSDATE 1 EFF_STATUS: CHAR(1) TREE_SETID: CHAR(5) BP_TREE_VALUE_FLG: CHAR(1) TREE_NAME: CHAR(18)

    PS_BP_BUDG_ACTV SETID: CHAR(5) BP_BUDG_ACTIVITY: CHAR(2) EFFDT: PSDATE

    PS_BP_CF_DEFN_REL CHARTFIELD: CHAR(18) (FK) BP_GL_INTERFACE: CHAR(1) BP_HRMS_INTERFACE: CHAR(1) BP_AM_INTERFACE: CHAR(1) BP_SUPPORT_CF: CHAR(1)

    PS_BP_ACTYP_OPT_HD SETID: CHAR(5) EFFDT: PSDATE EFF_STATUS: CHAR(1)

    PS_BP_ANAL_SETID SETID: CHAR(5) EFFDT: PSDATE EFF_STATUS: CHAR(1)

    PS_BP_DIM_CF_VAL SETID: CHAR(5) DIMENSION_ID: CHAR(30) (FK) EFFDT: PSDATE BP_VALUE_FROM: CHAR(30) BP_VALUE_TO: CHAR(30)

    PS_BP_CF_DEFN CHARTFIELD: CHAR(18) PS_BP_TREE_NODES SETID: CHAR(5) DIMENSION_ID: CHAR(30) (FK) EFFDT: PSDATE TREE_NODE: CHAR(20) SETID: CHAR(5) (FK) EFFDT: PSDATE (FK) BP_ALL_LEVELS: CHAR(1) BP_TREE_LEVEL: CHAR(10) BP_TREE_LEVEL2: CHAR(10) BP_DIM_SUM_LVL: CHAR(10) TREE_LEVEL_NUM: SMALLINT TREE_LEVEL_NUM2: SMALLINT BP_DIMSUM_LVL_NUM: SMALLINT PS_BP_BUDG_UNIT SETID: CHAR(5) EFFDT: PSDATE EFF_STATUS: CHAR(1) CF_ORDER: SMALLINT CF_ACTIVE_STATUS: CHAR(1) BP_SUPPORT_CF: CHAR(1) BP_BCTR_CF: CHAR(1) BP_DIMENSION_CF: CHAR(1) BP_EDITTABLE: CHAR(15) BP_RECNAME1: CHAR(15) BP_RECNAME2: CHAR(15) BP_RECNAME3: CHAR(15) BP_RECNAME4: CHAR(15) BP_RECNAME5: CHAR(15) EDITTABLE: CHAR(15)

    PS_BP_ACCT_TYP_OPT SETID: CHAR(5) BP_LEDGER_TYPE: CHAR(1) ACCOUNT_TYPE: CHAR(1) EFFDT: PSDATE EFF_STATUS: CHAR(1) BP_FLIP_SIGN: CHAR(1) BP_ANL_CALC: CHAR(1)

    PS_BP_ANAL_BASE SETID: CHAR(5) BP_ANAL_BASE_ID: CHAR(1) EFFDT: PSDATE DESCR: CHAR(30)

    PS_BP_EM_INST_TBL BP_EMAIL_INST_NO: INT BP_OPRID: CHAR(30) BP_EMAIL_DTTM: PSDATETIME BP_SUBJECT: CHAR(50) BP_EMAIL_TEXT: TEXT

    PS_BP_EM_TMPL TEMPLATE_ID: CHAR(15) DESCR: CHAR(30) BP_EM_TMPL_OPTN: CHAR(1) EMAIL_SUBJECT: CHAR(30) EMAILTEXT: TEXT

    PS_BP_EM_TMPL_VAR BP_EM_TMPL_OPTN: CHAR(1) BP_EM_BINDINDEX: CHAR(3) TEMPLATE_ID: CHAR(15) (FK)

    PS_BP_BC_DEFN SETID: CHAR(5) EFFDT: PSDATE CHARTFIELD: CHAR(18) EFF_STATUS: CHAR(1) TREE_SETID: CHAR(5) TREE_NAME: CHAR(18) BP_APPROVAL_FLG: CHAR(1) BP_PROJ_BUDG_FLG: CHAR(1) BP_PROJ_TREE: CHAR(18) 1

    PS_BP_MENUNAME BP_FUNCID: CHAR(2) MENUNAME: CHAR(30) MESSAGE_SET_NBR: INT MESSAGE_NBR: INT BP_INCL_LABEL: CHAR(1)

    PS_BP_EM_INST_USER BP_EMAIL_INST_NO: INT (FK) BP_OPRID: CHAR(30) (FK) BP_OPRID1: CHAR(30) EMAILID: CHAR(70)

    PS_BP_EM_TMPL_ADDR TEMPLATE_ID: CHAR(15) (FK) OPRID: CHAR(30) PS_BP_BC_DEFN_HDR SETID: CHAR(5) EFFDT: PSDATE EFF_STATUS: CHAR(1)

    PS_BP_PAGENAME BP_FUNCID: CHAR(2) (FK) MENUNAME: CHAR(30) (FK) PNLGRPNAME: CHAR(18) MESSAGE_SET_NBR: INT MESSAGE_NBR: INT BP_INCL_LABEL: CHAR(1)

    PS_BP_RATE_COMBO SETID: CHAR(5) BP_RATE_COMBO_ID: CHAR(10) RT_RATE_INDEX: CHAR(10) ACCOUNT_TYPE: CHAR(1) RT_TYPE: CHAR(5)

    PS_BP_BUD_CATEGORY SETID: CHAR(5) BP_BUDGET_CATEGORY: CHAR(15) EFFDT: PSDATE EFF_STATUS: CHAR(1) TREE_NAME: CHAR(18) TREE_LEVEL: CHAR(10)

    PS_BP_ACTIVITY_TBL SETID: CHAR(5) ACTIVITY_ID: CHAR(15) EFFDT: PSDATE EFF_STATUS: CHAR(1) DESCR: CHAR(30) PS_BP_INSTALLATION BP_GL_INTERFACE: CHAR(1) BP_HRMS_INTERFACE: CHAR(1) BP_AM_INTERFACE: CHAR(1) BP_PC_INTERFACE: CHAR(1) BP_SECUR_INTERFACE: CHAR(1) BP_GL_OVERRIDE: CHAR(1) BP_HRMS_OVERRIDE: CHAR(1) BP_POS_NBR_LAST: INT BP_PROCESSOR_COUNT: SMALLINT PS_BP_FILE_ATT_TBL BP_ATTACHUSERFILE: CHAR(50) ATTACHSYSFILENAME: CHAR(128) DESCR50: CHAR(50) ADDED_BY: CHAR(50) ADDED_DT: PSDATE

    PS_BP_TMPLT_TBL LEDGER_TEMPLATE: CHAR(10) RECNAME_COMBO_DATA: CHAR(15)

    1, 1 / 1, 1 -- 1:29:56 PM , 9/3/2004

    USERSECURITY -- Physical / <Main Subject Area>

    PS_BP_USER_ACTVTY BP_OPRID: CHAR(30) NOT NULL (FK) ROLENAME: CHAR(30) NOT NULL (FK) BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_BUDG_ACTIVITY: CHAR(2) NOT NULL

    PS_BP_ADV_USR_DIM BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_PLANNING_ID: CHAR(15) NOT NULL (FK) BUDGET_PHASE_ID: CHAR(30) NOT NULL (FK) BP_DATABASE_NAME: CHAR(50) NOT NULL (FK) BP_OPRID: CHAR(30) NOT NULL (FK) BP_ADV_ROLENAME: CHAR(80) NOT NULL (FK) BP_ADV_SLICE_DIM: CHAR(30) NOT NULL BP_ADV_MEMBER: CHAR(30) NOT NULL

    PS_BP_USER_BU BP_OPRID: CHAR(30) NOT NULL (FK) ROLENAME: CHAR(30) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL

    PS_BP_USER_CENTERS BP_OPRID: CHAR(30) NOT NULL (FK) ROLENAME: CHAR(30) NOT NULL (FK) BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_BUDGET_CENTER1: CHAR(15) NOT NULL BP_BUDGET_CENTER2: CHAR(15) NOT NULL

    PS_BP_USER BP_OPRID: CHAR(30) NOT NULL OPRDEFNDESC: CHAR(30) NOT NULL

    PS_BP_ADV_USR_ROLE BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_PLANNING_ID: CHAR(15) NOT NULL (FK) BUDGET_PHASE_ID: CHAR(30) NOT NULL (FK) BP_DATABASE_NAME: CHAR(50) NOT NULL (FK) BP_OPRID: CHAR(30) NOT NULL (FK) BP_ADV_ROLENAME: CHAR(80) NOT NULL

    PS_BP_ROLE_ACT_DIM ROLENAME: CHAR(30) NOT NULL BP_BUDG_ACTIVITY: CHAR(2) NOT NULL BP_ADV_ROLE_ID: CHAR(4) NOT NULL

    PS_BP_ADV_ROLE BP_ADV_ROLE_ID: CHAR(4) NOT NULL BP_ADV_ROLENAME: CHAR(80) NOT NULL PF_PART_ID: CHAR(20) NOT NULL

    PS_BP_ADV_USR BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_PLANNING_ID: CHAR(15) NOT NULL (FK) BUDGET_PHASE_ID: CHAR(30) NOT NULL (FK) BP_DATABASE_NAME: CHAR(50) NOT NULL BP_OPRID: CHAR(30) NOT NULL

    PS_BP_ADV_SLICE BP_ADV_SLICE_DIM: CHAR(30) NOT NULL

    PS_BP_ADV_ROLE_DIM BP_ADV_ROLE_ID: CHAR(4) NOT NULL (FK) BP_ADV_SLICE_DIM: CHAR(30) NOT NULL

    PS_BP_PHASES BUSINESS_UNIT: CHAR(5) NOT NULL BP_PLANNING_ID: CHAR(15) NOT NULL BUDGET_PHASE_ID: CHAR(30) NOT NULL START_DT: PSDATE NOT NULL END_DT: PSDATE NOT NULL TREE_LEVEL: CHAR(10) NOT NULL HOLD_PHASE: CHAR(1) NOT NULL BP_PLAN_MDL_STATUS: CHAR(1) NOT NULL BAM_MODEL_ID: CHAR(20) NOT NULL PROCESS_INSTANCE: DECIMAL(10) NOT NULL

    PS_BP_ACTV_ROLE BP_BUDG_ACTIVITY: CHAR(2) NOT NULL BP_ADV_ROLENAME: CHAR(80) NOT NULL

    PS_BP_FUNC_BY_ROLE BP_FUNCID: CHAR(2) NOT NULL (FK) ROLENAME: CHAR(30) NOT NULL

    PS_BP_ADV_DB_USER BP_DATABASE_NAME: CHAR(50) NOT NULL BP_OPRID: CHAR(30) NOT NULL BUSINESS_UNIT: CHAR(5) NOT NULL (FK) BP_PLANNING_ID: CHAR(15) NOT NULL (FK) BUDGET_PHASE_ID: CHAR(30) NOT NULL (FK)

    PS_BP_FUNCID_SEQ BP_FUNCID: CHAR(2) NOT NULL SEQUENCE_NBR: SMALLINT NOT NULL MESSAGE_SET_NBR: INT NOT NULL MESSAGE_NBR: INT NOT NULL CONTNAME: CHAR(30) NOT NULL CONTNAMEWORK: CHAR(30) NOT NULL

    1, 1 / 1, 1 -- 1:30:49 PM , 9/3/2004

    You might also like