GPSC_RM_PROCESS

(SQL Table)
Index Back

Remote Process List Definition

Remote Process List Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 EFFDT Date(10) DATE Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_AC4_VW

5 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_AC4_VW

6 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation
7 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

Prompt Table: GP_ENT_MIN_VW

8 PIN_MIN_NUM Number(8,0) INTEGER NOT NULL Pin Number

Prompt Table: %GP_EDIT_FLD6

9 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.