FBC

#	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