Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: POSN_LABOR_DIST_SLOT

Description Uses data from the POSITION_LABOR_DISTRIBUTION view, displays up to ten sets of values pertaining to ledger accounts.
Key & Frequency One row per position per fiscal year.
Recommended Search Columns POSITION, BUDGET, BUDGET_PHASE, FISCAL_YEAR
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DATE Date record was inserted or updated. DATE

NA

SYSDATE

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
BUDGET System defined code for the position's budget identification number. VARCHAR2(63)

NBRPLBD

NBRPLBD_OBUD_CODE

NO

NO
BUDGET_PHASE User-defined unique identifier of a budget phase identifier. VARCHAR2(63)

NBRPLBD

NBRPLBD_OBPH_CODE

NO

NO
CHART_OF_ACCOUNTS1 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS10 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS2 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS3 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS4 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS5 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS6 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS7 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS8 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS9 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBRPLBD

NBRPLBD_COAS_CODE

NO

NO
DISTRIBUTION_BUDGET1 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET10 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET2 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET3 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET4 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET5 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET6 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET7 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET8 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
DISTRIBUTION_BUDGET9 Amount of position total budget charged to this accounting distribution. NUMBER

NBRPLBD

NBRPLBD_BUDGET

NO

NO
EXTERNAL_ACCOUNT1 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT10 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT2 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT3 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT4 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT5 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT6 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT7 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT8 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
EXTERNAL_ACCOUNT9 System account distribution code to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

NBRPLBD

NBRPLBD_FISC_CODE

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
PERCENTAGE1 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE10 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE2 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE3 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE4 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE5 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE6 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE7 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE8 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
PERCENTAGE9 Percent of positions budget to be applied to this labor distribution. NUMBER

NBRPLBD

NBRPLBD_PERCENT

NO

NO
POSITION Position number. VARCHAR2(63)

NBRPLBD

NBRPLBD_POSN

NO

NO
POSITION_ACCOUNT1 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT10 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT2 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT3 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT4 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT5 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT6 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT7 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT8 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT9 System defined code which The position account to be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCT_CODE

NO

NO
POSITION_ACCOUNT_INDEX1 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX10 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX2 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX3 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX4 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX5 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX6 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX7 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX8 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACCOUNT_INDEX9 An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACCI_CODE

NO

NO
POSITION_ACTIVITY1 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY10 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY2 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY3 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY4 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY5 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY6 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY7 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY8 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_ACTIVITY9 System defined code that defines the activity to which the position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ACTV_CODE

NO

NO
POSITION_FUND1 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND10 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND2 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND3 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND4 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND5 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND6 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND7 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND8 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_FUND9 System defined code that identifies the fund to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_FUND_CODE

NO

NO
POSITION_LOCATION1 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION10 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION2 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION3 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION4 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION5 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION6 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION7 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION8 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_LOCATION9 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_LOCN_CODE

NO

NO
POSITION_ORGANIZATION1 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION10 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION2 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION3 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION4 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION5 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION6 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION7 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION8 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_ORGANIZATION9 System defined code that identifies the organization to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_ORGN_CODE

NO

NO
POSITION_PROGRAM1 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM10 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM2 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM3 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM4 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM5 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM6 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM7 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM8 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
POSITION_PROGRAM9 System defined code that identifies the program to which this position should be charged. VARCHAR2(63)

NBRPLBD

NBRPLBD_PROG_CODE

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO


Ver: 9.2