FBC_CI_VW (SQL View)	Index Back
FBC_CI_VW -- For CI This view: FBC_CI_VW has the same structure as the record: FBC. 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.

FBC_CI_VW

(SQL View)

FBC_CI_VW -- For CI

This view: FBC_CI_VW has the same structure as the record: FBC. 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.BO_ID ,A.STATUS_REG ,RBF_BC_TYPE ,A.EST_LIFE_VAL ,CREDIT_SCORE ,A.RISK_GRADE ,A.CREDIT_SCORE_DATE ,A.LANGUAGE_SKILL ,A.COUNTRY ,A.COUNTRY_OTHER ,A.SECRET_PASSWORD ,A.VERIFIED_BY ,A.VERIFIED_DATE ,A.DO_NOT_SHARE , %subrec(RB_AUDIT_SBR, A) FROM PS_FBC A

Parent record: BC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 STATUS_REG Character(4) VARCHAR2(4) NOT NULL BC Extension table status registration field
1=Prospect
2=Suspect

3 RBF_BC_TYPE Character(4) VARCHAR2(4) NOT NULL BC Type
ALTC=Alternate Capacity
COMP=Company
PART=Partnership
PERS=Person
SITE=Site

4 EST_LIFE_VAL Number(27,3) DECIMAL(26,3) NOT NULL Estimated Life Value of the BC Extension table

5 CREDIT_SCORE Number(4,0) SMALLINT NOT NULL Credit score field of the BC extension table

6 RISK_GRADE Number(3,0) SMALLINT NOT NULL Risk Grade for BC extension

7 CREDIT_SCORE_DATE Date(10) DATE Credit Score Date of the BC table

8 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Spoken Language Code

9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

10 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table: COUNTRY_TBL

11 SECRET_PASSWORD Character(30) VARCHAR2(30) NOT NULL This field is used for storing the secret password for a CDM object in the financial acpplication.

12 VERIFIED_BY Character(50) VARCHAR2(50) NOT NULL Verified By of the BC extension table

13 VERIFIED_DATE Date(10) DATE Verified Date of the BC extension table

14 DO_NOT_SHARE Character(1) VARCHAR2(1) NOT NULL Do Not Share field of the BC extension table
Y/N Table Edit
Default Value: N

15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

19 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.

20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	STATUS_REG	Character(4)	VARCHAR2(4) NOT NULL	BC Extension table status registration field 1=Prospect 2=Suspect
3	RBF_BC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	BC Type ALTC=Alternate Capacity COMP=Company PART=Partnership PERS=Person SITE=Site
4	EST_LIFE_VAL	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Life Value of the BC Extension table
5	CREDIT_SCORE	Number(4,0)	SMALLINT NOT NULL	Credit score field of the BC extension table
6	RISK_GRADE	Number(3,0)	SMALLINT NOT NULL	Risk Grade for BC extension
7	CREDIT_SCORE_DATE	Date(10)	DATE	Credit Score Date of the BC table
8	LANGUAGE_SKILL	Character(2)	VARCHAR2(2) NOT NULL	Spoken Language Code
9	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
10	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT Prompt Table: COUNTRY_TBL
11	SECRET_PASSWORD	Character(30)	VARCHAR2(30) NOT NULL	This field is used for storing the secret password for a CDM object in the financial acpplication.
12	VERIFIED_BY	Character(50)	VARCHAR2(50) NOT NULL	Verified By of the BC extension table
13	VERIFIED_DATE	Date(10)	DATE	Verified Date of the BC extension table
14	DO_NOT_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Do Not Share field of the BC extension table Y/N Table Edit Default Value: N
15	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
16	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
17	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
18	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
19	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.
20	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time