RC_BUS_PROCESS

(SQL Table)
 Index Back

Business Process

This table will store Business Processes. These Business Processes will be attached to cases to control progress through cases that require many tasks.

  • Related Language Record: RC_BUS_PROC_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 BUS_PROJ_TYPE Character(1) VARCHAR2(1) NOT NULL Business Project Type
    M=Main Business Project
    N=Sub-Business Project
    4 SET_NBP_OUTCOME Character(1) VARCHAR2(1) NOT NULL Set Outcome
    A=Automatically
    M=Manually

    Default Value: A

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: I

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: RC_BUS_PROCESS.DESCR

    8 START_PHASE Character(15) VARCHAR2(15) NOT NULL Start Phase

    Prompt Table: RC_ACTIVITY

    9 TIME_UNIT Character(1) VARCHAR2(1) NOT NULL Unit of time to use in completion times for Business Process tracking.
    D=Day(s)
    H=Hour(s)
    M=Minute(s)

    Default Value: M

    10 TIME_CALC_MAX Number(15,0) DECIMAL(15) NOT NULL Maximum Calulated Time used in Business Process tracking.
    11 TIME_CALC_STD Number(15,0) DECIMAL(15) NOT NULL Standard Calculated Time used in Business Process tracking.
    12 TIME_MAXIMUM Number(15,0) DECIMAL(15) NOT NULL Maximum user-entered time used in Business Process tracking.
    13 TIME_STANDARD Number(15,0) DECIMAL(15) NOT NULL Standard user-entered time used in Business Process tracking.
    14 RC_VALIDATE Character(1) VARCHAR2(1) NOT NULL Field for validation purposed in Business Process tracking.

    Y/N Table Edit

    Default Value: N

    15 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    17 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RC_RECVIEWS_VW

    18 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name

    Prompt Table: RC_RECVIEWS_VW

    19 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: RC_RECFIELDS1_V

    20 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2

    Prompt Table: RC_RECFIELDS2_V

    21 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

    Prompt Table: RC_AUTH_BCNAME

    22 BCMETHOD Character(30) VARCHAR2(30) NOT NULL Method

    Prompt Table: RC_AUTH_BCMETHD

    23 NOTES Long Character CLOB Budget Notes
    24 START_DT Date(10) DATE Start date field to store start date value.
    25 END_DT Date(10) DATE This field stores the end date values.
    26 BP_TRACE_FLAG Character(1) VARCHAR2(1) NOT NULL Business Project Trace Flag
    27 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    28 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    29 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    30 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    31 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    32 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    33 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    34 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    35 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    36 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    37 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    38 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    39 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    40 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    41 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    42 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    43 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N