GPBR_NRP_AVV_AD

(SQL Table)
 Index Back

Averages Brazil

Averages Brazil

  • Parent record: GPBR_AVG_VERS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GPBR_AVG_VERSION Character(10) VARCHAR2(10) NOT NULL Averages BRA Version
    3 EFFDT Date(10) DATE Effective Date
    4 GPBR_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL Entry type element
    10=Earnings
    20=Deductions
    5 GPBR_PIN_AVG_NUM Number(8,0) INTEGER NOT NULL Averages PIN Number
    6 GPBR_PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL Period Type : Acquisitive Period, Last Months, Define Period Averages - Brazil
    10=Acquisitive Period
    20=Year
    30=Defined Period
    7 GPBR_FROM_DATE Character(2) VARCHAR2(2) NOT NULL Averages -Brazil From Date
    10=Current
    20=Before
    30=Defined
    40=Element Name
    8 BEGIN_DT Date(10) DATE Begin Date
    9 GPBR_TO_DATE Character(2) VARCHAR2(2) NOT NULL Averages -Brazil From Date
    10=Months
    20=Defined
    30=Element Name
    10 GPBR_MONTHS_NBR Number(2,0) SMALLINT NOT NULL Averages - Brazil Number of Months
    11 END_DT Date(10) DATE end date
    12 GPBR_AVG_TYPE Character(2) VARCHAR2(2) NOT NULL Averages - Brazil Average Type
    10=Units
    20=Units * Percentage
    30=Amount
    40=Percentage
    13 GPBR_CORRECT_AMT Character(2) VARCHAR2(2) NOT NULL Averages - Brazil Correct Amount
    10=Don't Correct
    20=Correct Amount
    30=Index by Hourly Salary
    40=Reverse Sign
    14 GPBR_CORRECT_ID Character(10) VARCHAR2(10) NOT NULL Averages - Brazil Correct ID
    15 GPBR_DIVIDE_IND Character(2) VARCHAR2(2) NOT NULL Averages - Brazil Divide by
    10=Months
    20=Worked Months
    16 GPBR_DIVIDE_NBR Number(2,0) SMALLINT NOT NULL Averages - Brazil Divide Nbr
    17 GPBR_FREQUENCY Number(2,0) SMALLINT NOT NULL Averages - Brazil Frequency
    18 GPBR_HIGHEST Number(2,0) SMALLINT NOT NULL Averages - Brazil Highest Amount