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

SGHE 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

NA

SYSDATE

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

NA

NA

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

NBRPLBD

NBRPLBD_OBUD_CODE

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

NBRPLBD

NBRPLBD_OBPH_CODE

CHART_OF_ACCOUNTS1 Chart Of Accounts 1 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS10 Chart Of Accounts 10 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS2 Chart Of Accounts 2 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS3 Chart Of Accounts 3 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS4 Chart Of Accounts 4 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS5 Chart Of Accounts 5 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS6 Chart Of Accounts 6 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS7 Chart Of Accounts 7 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS8 Chart Of Accounts 8 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

CHART_OF_ACCOUNTS9 Chart Of Accounts 9 Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

NBRPLBD

NBRPLBD_COAS_CODE

DISTRIBUTION_BUDGET1 Distribution Budget 1 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET10 Distribution Budget 10 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET2 Distribution Budget 2 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET3 Distribution Budget 3 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET4 Distribution Budget 4 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET5 Distribution Budget 5 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET6 Distribution Budget 6 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET7 Distribution Budget 7 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET8 Distribution Budget 8 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

DISTRIBUTION_BUDGET9 Distribution Budget 9 Amount of position total budget charged to this accounting distribution. NUMBER  

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_FISC_CODE

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

NA

NA

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

NA

NA

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

POSITION Position Position number. VARCHAR2(63)  

NBRPLBD

NBRPLBD_POSN

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACCI_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NA

NA



Ver: 9.0