GP_PIN_PR9_VW

(SQL View)
 Index Back

Prompt View - Process pin

Prompt View on Run Type Panel for Processes.

SELECT C.OPRID ,D.CALC_TYPE ,B.PIN_NUM ,D.EFFDT ,B.PIN_NM ,D.EFF_STATUS ,B.DESCR ,B.COUNTRY FROM PS_GP_PIN B ,PS_GP_OPR_RULE_PRF C ,PS_GP_PROCESS D WHERE B.PIN_NUM = D.PIN_NUM AND B.PIN_NUM < 50000000 AND (B.USED_BY = 'A' OR C.USED_BY = 'A' OR B.COUNTRY = C.COUNTRY)

  • Related Language Record: GP_PIN_PR9_VL

    • # 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 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
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    4 EFFDT Date(10) DATE Effective Date
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country