| # |
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
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
|