GPBR_NRP_AVV_VW

(SQL View)
 Index Back

Averages Version Brazil

Averages Version Brazil

SELECT GPBR_AVG_VERSION ,EFFDT ,GPBR_ENTRY_TYPE ,GPBR_PIN_AVG_NUM + 50000000 ,GPBR_PERIOD_TYPE ,GPBR_FROM_DATE ,GPBR_PIN_FROM_NUM + 50000000 ,BEGIN_DT ,GPBR_TO_DATE ,GPBR_PIN_TO_NUM + 50000000 ,GPBR_MONTHS_NBR ,END_DT ,GPBR_AVG_TYPE ,GPBR_CORRECT_AMT ,GPBR_CORRECT_ID ,GPBR_DIVIDE_IND ,GPBR_DIVIDE_NBR ,GPBR_FREQUENCY ,GPBR_HIGHEST FROM PS_GPBR_AVG_VERS_E

  • Parent record: GPBR_AVG_VERS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_AVG_VERSION Character(10) VARCHAR2(10) NOT NULL Averages BRA Version
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPBR_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL Entry type element
    10=Earnings
    20=Deductions

    Default Value: 10

    4 GPBR_PIN_AVG_NUM Number(8,0) INTEGER NOT NULL Averages PIN Number

    Prompt Table: %RECNAME_EDIT

    5 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

    Default Value: 10

    6 GPBR_FROM_DATE Character(2) VARCHAR2(2) NOT NULL Averages -Brazil From Date
    10=Current
    20=Before
    30=Defined
    40=Element Name

    Default Value: 30

    7 GPBR_PIN_FROM_NUM Number(8,0) INTEGER NOT NULL Element Definition for Averages from Field

    Prompt Table: GPBR_DT_VW

    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

    Default Value: 20

    10 GPBR_PIN_TO_NUM Number(8,0) INTEGER NOT NULL Element Name Averages definitions to

    Prompt Table: GPBR_DT_VW

    11 GPBR_MONTHS_NBR Number(2,0) SMALLINT NOT NULL Averages - Brazil Number of Months
    12 END_DT Date(10) DATE end date
    13 GPBR_AVG_TYPE Character(2) VARCHAR2(2) NOT NULL Averages - Brazil Average Type
    10=Units
    20=Units * Percentage
    30=Amount
    40=Percentage

    Default Value: 10

    14 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

    Default Value: 10

    15 GPBR_CORRECT_ID Character(10) VARCHAR2(10) NOT NULL Averages - Brazil Correct ID
    16 GPBR_DIVIDE_IND Character(2) VARCHAR2(2) NOT NULL Averages - Brazil Divide by
    10=Months
    20=Worked Months

    Default Value: 10

    17 GPBR_DIVIDE_NBR Number(2,0) SMALLINT NOT NULL Averages - Brazil Divide Nbr
    18 GPBR_FREQUENCY Number(2,0) SMALLINT NOT NULL Averages - Brazil Frequency
    19 GPBR_HIGHEST Number(2,0) SMALLINT NOT NULL Averages - Brazil Highest Amount