GPDE_RC_SI10

(SQL Table)
Index Back

Run Control SI Contributions

Run Control SI Contributions

  • Parent Record Of GPDE_RC_SI10RCV
  • # 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
    6 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    7 GPDE_DV_RCVER_ID Character(8) VARCHAR2(8) NOT NULL Provider ID

    Prompt Table: GPDE_DV_RCVR_VW

    8 GPDE_RC_YR_CLOSE Character(1) VARCHAR2(1) NOT NULL Tax Year Close

    Y/N Table Edit

    Default Value: N

    9 GPDE_RC_RESET1 Character(1) VARCHAR2(1) NOT NULL Use for reporting

    Y/N Table Edit

    Default Value: N

    10 GPDE_RC_PRN_DUE25 Character(1) VARCHAR2(1) NOT NULL Indicator on the SI-Contributionlist, that the due-date is 25th of the month

    Y/N Table Edit

    11 GPDE_AL_OPRNAME Character(11) VARCHAR2(11) NOT NULL Executing Clerk

    Prompt Table: PERS_SRCH_GBL

    12 GPDE_AL_GENDER Character(1) VARCHAR2(1) NOT NULL gender of an EE
    M=Mr
    W=Mrs
    13 GPDE_AL_CONTACT_NM Character(50) VARCHAR2(50) NOT NULL executing clerk
    14 GPDE_AL_PHONE Character(24) VARCHAR2(24) NOT NULL phone number of an employee

    Prompt Table: GPDE_AL_PH_SRCH

    15 GPDE_AL_FAX Character(24) VARCHAR2(24) NOT NULL Fax number of an employee

    Prompt Table: GPDE_AL_PH_SRCH

    16 GPDE_AL_EMAIL Character(70) VARCHAR2(70) NOT NULL email address of an employee

    Prompt Table: GPDE_AL_EM_SRCH