GP_GENRPT_RC

(SQL Table)
Index Back

Run control generic reports

Run control record for generic reports

  • Parent Record Of GP_GENRPT_RC2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
    O=Specified Language
    R=Recipient's Language

    Default Value: O

    5 GP_GENRPT_ID Character(10) VARCHAR2(10) NOT NULL Code of the generic report

    Prompt Table: GP_GENRPT_TBL

    6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GP_CAL_RUN

    7 GP_GENRPT_CALID1 Character(10) VARCHAR2(10) NOT NULL Calendar Period used for begin date

    Prompt Table: GP_CAL_PRD

    8 BGN_DT Date(10) DATE Begin Date
    9 GP_GENRPT_CALID2 Character(10) VARCHAR2(10) NOT NULL Calendar Period used for end date

    Prompt Table: GP_CAL_PRD

    10 END_DT Date(10) DATE end date
    11 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

    Default Value: P

    12 GP_GENRPT_SORT_OPT Character(2) VARCHAR2(2) NOT NULL Sort option for generic reports
    10=Employee ID, Employee Rcd Nbr
    20=Name, Employee Rcd Nbr
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    14 GP_GENRPT_PAYEES Character(1) VARCHAR2(1) NOT NULL Indicates if the detail of the payees must be printed or not

    Y/N Table Edit

    Default Value: Y

    15 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    16 GB_EFFDT Date(10) DATE Group As Of Date
    17 GB_REFINE_DATE Date(10) DATE Refinement Date
    18 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
    19 GP_GENRPT_BLD_GRP Character(1) VARCHAR2(1) NOT NULL Indicates if the group build must be rebuilt or not

    Y/N Table Edit

    Default Value: N