GP_NRP_PIMDC_AD

(SQL Table)
Index Back

Manual Positive Input Comment

This contains Comments for PI entered manually into the system.

  • Audit Record: GP_PI_DEL_AUD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    3 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    7 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
    8 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    9 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
    10 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    11 COMMENTS Long Character CLOB Comment