Go To View:  RETURN TO REPORTING VIEW 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 Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

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

NA

NA

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

NBRPLBD

NBRPLBD_OBUD_CODE

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

NBRPLBD

NBRPLBD_OBPH_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_COAS_CODE

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_BUDGET

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_ACCT_CODE_EXTERNAL

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

NBRPLBD

NBRPLBD_FISC_CODE

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

NA

NA

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

NA

NA

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

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

NBRPLBD

NBRPLBD_PERCENT

POSITION Position number. VARCHAR2(63)

NBRPLBD

NBRPLBD_POSN

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

NBRPLBD

NBRPLBD_ACCT_CODE

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

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

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

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

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

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

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

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

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

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

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_ACTV_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_FUND_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_LOCN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_ORGN_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NBRPLBD

NBRPLBD_PROG_CODE

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

NA

NA



Ver: 8.1