SCC_CG_RUNCTL

(SQL Table)
 Index Back

CommGen Run Control

Communication Generation run control contains fields that are used as input parameters for the CommGen process. Input data is retrieved from this record when the CommGen Process is requested from the Process Scheduler.

  • Parent Record Of SCC_CG_ENC_RCTL

    • # 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 XTRCT_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL Extract File Format
    C=Comma Separated Values
    J=JetForm
    L=Line Printer
    O=Other
    W=MS-Word

    Default Value: C

    4 CG_COMM_ID_OPTION Character(1) VARCHAR2(1) NOT NULL Communication ID Select Option
    A=All IDs
    E=All Person IDs
    O=One Org ID
    P=Population Selection
    R=All Org IDs
    S=One Person ID

    Default Value: A

    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: COMM_LTR_SRCH

    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: COMM_ORG_SRCH

    7 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    8 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    9 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    10 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    13 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    14 SCC_CG_DFLT_TMPL Character(1) VARCHAR2(1) NOT NULL Use Default Template
    D=Use Default Template
    E=Do Not Produce Communication

    Default Value: D

    15 SCC_LANG_OPT Character(1) VARCHAR2(1) NOT NULL Language Option
    R=Preferred
    S=Specified

    Default Value: S

    16 SCC_COMM_LANG Character(3) VARCHAR2(3) NOT NULL Language Used
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    17 SCC_MTHD_OPT Character(1) VARCHAR2(1) NOT NULL Method Option
    R=Preferred
    S=Specified

    Default Value: S

    18 SCC_COMM_MTHD Character(1) VARCHAR2(1) NOT NULL Method Used
    B=Publication
    D=Document
    E=E-Mail
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web
    19 SALUT_NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Salutation Name

    Prompt Table: NAME_USAGE_VW

    20 ADDR_NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Address Name

    Prompt Table: NAME_USAGE_VW

    21 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    22 JOINT_NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Joint Name Usage

    Prompt Table: J_NAME_USAGE_VW

    23 ORG_RCP_USAGE Character(10) VARCHAR2(10) NOT NULL Organization Recipient Usage

    Prompt Table: SCC_ORG_USAGE

    24 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: %EDITTABLE2

    25 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

    Prompt Table: SCC_CG_XMLP_RPT

    26 DATE_PRINTED_OPT Character(1) VARCHAR2(1) NOT NULL Date Letter Printed Option
    C=Communication Date
    D=User Supplied Date
    S=System Date

    Default Value: S

    27 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    28 DATE_COMPLETED_OPT Character(1) VARCHAR2(1) NOT NULL Date Activity Completed Option
    C=Communication Date
    D=User Supplied Date
    S=System Date

    Default Value: S

    29 COMPLETED_DT Date(10) DATE Date Activity Completed
    30 FROM_DT Date(10) DATE NOT NULL From Date

    Default Value: %date

    31 TO_DT Date(10) DATE NOT NULL To Date

    Default Value: %date

    32 PRODUCE_COMM Character(1) VARCHAR2(1) NOT NULL Produce Communication

    Y/N Table Edit

    Default Value: Y

    33 COMPLETE_COMM Character(1) VARCHAR2(1) NOT NULL Complete Communication

    Y/N Table Edit

    Default Value: Y

    34 EXTRACT_NAME_USAGE Character(10) VARCHAR2(10) NOT NULL ID Extract Name Usage

    Prompt Table: NAME_USAGE_VW

    35 CNTC_NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Contact Name

    Prompt Table: NAME_USAGE_VW

    36 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
    37 CG_SORT_OPTION_LTR Character(1) VARCHAR2(1) NOT NULL Sort Option for Comm Gen
    1=Country, Postal
    2=Country, Postal by ID Type
    3=All Alphabetically by ID Type

    Default Value: 1

    38 PRINT_OPTION Character(1) VARCHAR2(1) NOT NULL Send to Printer

    Y/N Table Edit

    Default Value: N

    39 DESTPRINTER Character(127) VARCHAR2(127) NOT NULL Destination Printer
    40 SCC_CG_PREVIEW Character(1) VARCHAR2(1) NOT NULL Online Preview

    Y/N Table Edit

    Default Value: N

    41 SCC_CG_EMAL_FROM Character(70) VARCHAR2(70) NOT NULL CommGen Email Address
    42 CS_SUBJECT Character(254) VARCHAR2(254) NOT NULL Message Subject
    43 SCC_CG_EMAL_REPLY Character(70) VARCHAR2(70) NOT NULL CommGen Email Address
    44 SCC_CG_EMAL_SENDER Character(70) VARCHAR2(70) NOT NULL CommGen Email Address
    45 SCC_CG_EMAL_BOUNCE Character(70) VARCHAR2(70) NOT NULL CommGen Email Address
    46 SCC_CG_EMAL_IMP Character(2) VARCHAR2(2) NOT NULL CommGen Email importance
    05=Low Importance
    10=Normal Importance
    15=High importance

    Default Value: 10

    47 SCC_CG_EMAL_SEN Character(2) VARCHAR2(2) NOT NULL CommGen Email sensitivity
    05=normal
    10=personal
    15=private
    20=company-confidential

    Default Value: 05

    48 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    49 SCC_CG_CREATE_ENV Character(1) VARCHAR2(1) NOT NULL Comm Gen Generate Envlopes option.

    Y/N Table Edit

    Default Value: N

    50 SCC_CG_CREATE_LBLS Character(1) VARCHAR2(1) NOT NULL Comm Gen Generate Labels option.

    Y/N Table Edit

    Default Value: N

    51 SCC_CG_ENV_PRINTER Character(127) VARCHAR2(127) NOT NULL Printer Name for Comm Gen Envelopes.
    52 SCC_CG_ENV_RPTNM Character(12) VARCHAR2(12) NOT NULL Report Definition ID for Comm Gen Envelopes.
    53 SCC_CG_LBL_PRINTER Character(127) VARCHAR2(127) NOT NULL Printer name for Comm Gen Labels.
    54 SCC_CG_LBL_RPTNM Character(12) VARCHAR2(12) NOT NULL Report Definition ID for Comm Gen Labels.
    55 SCC_CG_FILE_OPTION Character(1) VARCHAR2(1) NOT NULL CommGen Send to File Output Option

    Y/N Table Edit

    Default Value: N

    56 USE_PREFERRED_EMLP Character(1) VARCHAR2(1) NOT NULL Option to specify whether to use preferred email address for a person communication.

    Y/N Table Edit

    Default Value: N