| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 6 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 7 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 8 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 9 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 10 |
GPBR_VACN_DAYS_AP |
Number(3,0) |
SMALLINT NOT NULL |
Vacation Days Per Acquisitive Period
|
| 11 |
GPBR_NEG_BALANCE |
Number(1,0) |
SMALLINT NOT NULL |
Allow Negative Balance Vacation Parameters Brazil
|
| 12 |
GPBR_NEG_BAL_LIMIT |
Number(2,0) |
SMALLINT NOT NULL |
Negative Balance Limit
|
| 13 |
GPBR_LEAVES_PER_AP |
Number(2,0) |
SMALLINT NOT NULL |
Vacation Days per Acquisitive Period
|
| 14 |
GPBR_MIN_AGE_PART |
Number(2,0) |
SMALLINT NOT NULL |
Minimum Age for Partiality
|
| 15 |
GPBR_MAX_AGE_PART |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Age for Partiality
|
| 16 |
GPBR_MIN_DAY_ALLOW |
Number(2,0) |
SMALLINT NOT NULL |
Minimum Days Allowed by Leave
|
| 17 |
GPBR_MAX_VAC_PER |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Vacation Days per Period
|
| 18 |
GPBR_MAX_PCT_LEAVE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Percent per Leave
|
| 19 |
GPBR_CRE_TREATMENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Treatment
01=Starting Month
02=End of Vacations
03=Proportional Vacation Days
|
| 20 |
GPBR_13TH_CALC_SEP |
Number(1,0) |
SMALLINT NOT NULL |
13th Calculate Separately
|
| 21 |
GPBR_NEED_CONFIRM |
Number(1,0) |
SMALLINT NOT NULL |
Needs Confirmation for Program
|
| 22 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
Prompt Table:
GP_PIN_ABSTK_VW
|
| 23 |
GPBR_PIN_TAKEC_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take Credit Brazil
Prompt Table:
GP_PIN_ABSTK_VW
|
| 24 |
PIN_ENT_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_AE5_VW
|
| 25 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 26 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 27 |
BEGIN_DT |
Date(10) |
DATE NOT NULL |
Begin Date
Default Value: %DATE
|
| 28 |
END_DATE |
Date(10) |
DATE |
End Date
Default Value: %DATE
|
| 29 |
GPBR_AP_VAC_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Acquisitive Period Status
01=In Progress
02=Open
03=Close per Absence
04=Close Expired
05=Close
|
| 30 |
SERVICE_YEARS |
Number(2,0) |
SMALLINT NOT NULL |
Years of Service
|
| 31 |
GPBR_CALC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Calculated Vacation Days GP Brazil
|
| 32 |
GPBR_BAL_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Balance Vacation Days Brazil
|
| 33 |
GPBR_ADJ_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Leave Days Brazil
|
| 34 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 35 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 36 |
GPBR_DATE_BGN_NEXT |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
End Date Acquisitive Period Variable
|
| 37 |
GPBR_DATE_END_PER |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
End Date Acquisitive Period Variable
|
| 38 |
GPBR_DATE_INI_PER |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Begin Date Acquisitive Period Variable
|
| 39 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 40 |
ACM_THRU_DT |
Date(10) |
DATE |
Through Date
|
| 41 |
USER_ADJ_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
User Adjustment Value
|
| 42 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 43 |
EMPLID_TO1 |
Character(11) |
VARCHAR2(11) NOT NULL |
Used in SS Framework
|
| 44 |
DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days
|
| 45 |
BAL_ACM_SFX |
Character(5) |
VARCHAR2(5) NOT NULL |
Element Accum Suffix
|
| 46 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 47 |
SUFFIX_SEPARATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Element Suffix Separator
|
| 48 |
PIN_AA_ELEM_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 49 |
PRC_BGN_DT |
Date(10) |
DATE |
The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
|
| 50 |
PRC_END_DT |
Date(10) |
DATE |
The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.
|
| 51 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 52 |
END_DT |
Date(10) |
DATE |
end date
|
| 53 |
ABS_BGN_DT |
Date(10) |
DATE NOT NULL |
Absence Begin Date
Default Value: %DATE
|
| 54 |
ABS_END_DT |
Date(10) |
DATE |
Absence End Date
|
| 55 |
GPBR_LEAVE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Leave Status
01=Programmed
03=Calculated
04=Confirmed
05=Cancelled
06=Closed
Default Value: 01
|
| 56 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 57 |
DATE_CLEAR |
Date(10) |
DATE |
Date Cleared
|
| 58 |
PIN_VAL1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 59 |
PIN_VAL2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 60 |
PIN_VAL3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 61 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|