RBF_SERVICE_CIV

(SQL View)
 Index Back

CI view for RBF_SERVICE

This view has the same structure as RBF_SERVICE. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

SELECT A.SERVICE_ID ,A.FSI_SERVICE_TYPE ,A.SERVICE_NAME ,A.DESCR100 ,%subrec(RB_MARKET_SBR, A) ,%subrec(RB_AUDIT_SBR, A) FROM PS_RBF_SERVICE A

  • Related Language Record: RBF_SERVICE_LAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

    Default Value: NEXT

    2 FSI_SERVICE_TYPE Character(2) VARCHAR2(2) NOT NULL service types solely for FSI industry.
    BB=Business Banking
    BK=Banking
    IN=Insurance
    LO=Loan Service
    MG=Mortgage
    PB=Personal Banking
    WM=Wealth Management

    Prompt Table: RBF_SRVCTYPE_VW
    Set Control Field: FIELDVALUE

    3 SERVICE_NAME Character(30) VARCHAR2(30) NOT NULL Service Name
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    6 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    7 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    8 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    9 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    10 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.
    11 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time