| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Default Value: 999999
|
| 3 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
Default Value: GP_PIN.PIN_NM
|
| 4 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 5 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
Prompt Table:
GP_PIN_TYPE
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
FLD_FMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field format for Global Payroll elements
1=Character
2=Date
3=Monetary
4=Decimal
5=Element Pointer
6=Not Applicable
|
| 8 |
DEFN_ASOFDT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
DEFN_ASOFDT_OPTN
B=Calendar Period Begin Date
E=Calendar Period End Date
N=Not Applicable
P=Payment Date
R=Process Begin Date
S=Process End Date
Default Value: E
Prompt Table:
GP_DEFASOFDT_VW
|
| 9 |
CHECK_GENER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Generation Indicator
|
| 10 |
RECALC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Always Recalculate indicator
Y/N Table Edit
Default Value: N
|
| 11 |
USED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries
C=Specific Country
|
| 12 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY_VW
|
| 13 |
PIN_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Element Category
Prompt Table:
GP_PIN_CATEGORY
|
| 14 |
PIN_INDUSTRY |
Character(4) |
VARCHAR2(4) NOT NULL |
Element Industry
Prompt Table:
GP_PIN_INDUSTRY
|
| 15 |
PIN_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Element Owner
C=Customer Maintained
M=PS Delivered/Customer Modified
N=PS Delivered / Not Maintained
P=PS Delivered / Maintained
S=PS Delivered/Maintained/Secure
|
| 16 |
PIN_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Class
CU=Customary
NC=Not Classified
SM=Sample Data
ST=Statutory
SY=System Data
Default Value: NC
|
| 17 |
OVRD_IND_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar Level Override Ind
Y/N Table Edit
Default Value: N
|
| 18 |
OVRD_IND_PYENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Entity Override Ind
Y/N Table Edit
Default Value: N
|
| 19 |
OVRD_IND_PG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Group Override Indicator
Y/N Table Edit
Default Value: N
|
| 20 |
OVRD_IND_PYE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee Level Override Indicator
Y/N Table Edit
Default Value: N
|
| 21 |
OVRD_IND_PI |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Input Override Ind
Y/N Table Edit
Default Value: N
|
| 22 |
OVRD_IND_ELEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Element Level Override Ind
Y/N Table Edit
Default Value: N
|
| 23 |
OVRD_IND_SOVR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used on GP_PIN page to determine if any element definition overrides are allowed
Y/N Table Edit
Default Value: N
|
| 24 |
STORE_RSLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Store Results
Y/N Table Edit
Default Value: N
|
| 25 |
STORE_RSLT_IF_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Store Results if Zero
N=If Element Or Comp Is Non-Zero
X=If Element Is Non-Zero
Y=Always Store
Y/N Table Edit
Default Value: N
|
| 26 |
PIN_PARENT_NUM |
Number(8,0) |
INTEGER NOT NULL |
Parent Element Number
|
| 27 |
PIN_CUSTOM1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Customer FIelds
|
| 28 |
PIN_CUSTOM2 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM2
|
| 29 |
PIN_CUSTOM3 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM3 fields
|
| 30 |
PIN_CUSTOM4 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM4
|
| 31 |
PIN_CUSTOM5 |
Character(20) |
VARCHAR2(20) NOT NULL |
PIN_CUSTOM5
|
| 32 |
FCST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
Default Value: N
|
| 33 |
FCST_REQ_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used on GP_PIN to indicate whether forecasting is required for this element.
Default Value: N
|
| 34 |
PIN_DRIVER_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
GP_PIN_ACD_VW
|
| 35 |
ENTRY_TYPE_USER_F1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 36 |
PIN_USER_FLD1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
%GP_EDIT_FLD1
|
| 37 |
ENTRY_TYPE_USER_F2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 38 |
PIN_USER_FLD2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
%GP_EDIT_FLD2
|
| 39 |
ENTRY_TYPE_USER_F3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 40 |
PIN_USER_FLD3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
%GP_EDIT_FLD3
|
| 41 |
ENTRY_TYPE_USER_F4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 42 |
PIN_USER_FLD4_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
%GP_EDIT_FLD4
|
| 43 |
ENTRY_TYPE_USER_F5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 44 |
PIN_USER_FLD5_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
Prompt Table:
%GP_EDIT_FLD5
|
| 45 |
ENTRY_TYPE_USER_F6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table:
GP_ENT_USERF_VW
|
| 46 |
PIN_USER_FLD6_NUM |
Number(8,0) |
INTEGER NOT NULL |
Pin Number
Prompt Table:
%GP_EDIT_FLD6
|
| 47 |
RTO_DELTA_UF_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to defined what user fields to consider when summing retro or deltas
0=None
1=Through User Field 1
2=Through User Field 2
3=Through User Field 3
4=Through User Field 4
5=Through User Field 5
A=All User Fields Defined
Default Value: 0
|
| 48 |
LAST_UPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated Date-Time Stamp
|
| 49 |
LAST_UPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated User Name
|
| 50 |
AUTO_ASSIGNED_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto-Assigned Element Type
AR=Add to Arrears
BS=Base
NT=Amount Not Taken
PB=Payback
PC=Percent
RT=Rate
UN=Unit
|
| 51 |
GP_VERSION |
Character(18) |
VARCHAR2(18) NOT NULL |
Stores element version.
|
| 52 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 53 |
PIN_NUM_TGT |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|