GPBR_AVG_VW

(SQL View)
 Index Back

Averages Brazil

Averages Brazil

SELECT A.UNION_CD , A.EFFDT , B.RUN_TYPE , B.PIN_NUM , C.GPBR_PIN_AVG_NUM , C.GPBR_AVG_VERSION , C.GPBR_PERIOD_TYPE , C.GPBR_FROM_DATE , C.GPBR_PIN_FROM_NUM , C.BEGIN_DT , C.GPBR_TO_DATE , C.GPBR_PIN_TO_NUM , C.GPBR_MONTHS_NBR , C.END_DT , C.GPBR_AVG_TYPE , C.GPBR_CORRECT_AMT , C.GPBR_CORRECT_ID , C.GPBR_DIVIDE_IND , C.GPBR_DIVIDE_NBR , C.GPBR_FREQUENCY , C.GPBR_HIGHEST FROM PS_GPBR_AVERAGES A ,PS_GPBR_AVERAGES_E B ,PS_GPBR_AVG_VERS_E C WHERE A.UNION_CD = B.UNION_CD AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_GPBR_AVERAGES AA WHERE AA.UNION_CD = A.UNION_CD) AND A.EFFDT = B.EFFDT AND B.GPBR_AVG_VERSION = C.GPBR_AVG_VERSION AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_GPBR_AVG_VERS_E CC WHERE C.GPBR_AVG_VERSION = CC.GPBR_AVG_VERSION)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

Prompt Table: GPBR_UNION_PARM

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

Prompt Table: GP_RUN_TYPE

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

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

Prompt Table: %RECNAME_EDIT

6 GPBR_AVG_VERSION Character(10) VARCHAR2(10) NOT NULL Averages BRA Version
7 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

8 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

9 GPBR_PIN_FROM_NUM Number(8,0) INTEGER NOT NULL Element Definition for Averages from Field
10 BEGIN_DT Date(10) DATE Begin Date
11 GPBR_TO_DATE Character(2) VARCHAR2(2) NOT NULL Averages -Brazil From Date
10=Months
20=Defined
30=Element Name

Default Value: 20

12 GPBR_PIN_TO_NUM Number(8,0) INTEGER NOT NULL Element Name Averages definitions to
13 GPBR_MONTHS_NBR Number(2,0) SMALLINT NOT NULL Averages - Brazil Number of Months
14 END_DT Date(10) DATE end date
15 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

16 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

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

Default Value: 10

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