GPSC_ELM_PRCS

(SQL View)
 Index Back

Process List Definition

Process List Definition

SELECT PIN_NUM ,EFFDT ,EFF_STATUS ,PIN_GROSS_NUM ,PIN_NET_NUM ,CALC_TYPE ,ENTRY_TYPE_ID ,PIN_MIN_NUM ,GP_VERSION FROM PS_GP_PROCESS WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM ,EFFDT ,EFF_STATUS ,PIN_GROSS_NUM ,PIN_NET_NUM ,CALC_TYPE ,ENTRY_TYPE_ID ,PIN_MIN_NUM ,GP_VERSION FROM PS_GPSC_RM_PROCESS WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

  • Parent Record Of GPSC_ELM_PR_DTL GPSC_RM_PR_DTL

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