STOCK_BRNCH_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
2	ST_BROKERAGE_ID	Character(10)	VARCHAR2(10) NOT NULL	Brokerage ID Prompt Table: ST_BROKER_TBL
3	ST_BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Branch Identification Prompt Table: ST_BRKR_BRANCH
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CONTROL_NBR_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Control Number Prefix
7	CAPTIVE_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Options Captive Y/N Table Edit Default Value: N
8	CAPTIVE_ESPP	Character(1)	VARCHAR2(1) NOT NULL	Stock Purchases Captive Y/N Table Edit Default Value: N
9	BROKERAGE_FEES_IND	Character(1)	VARCHAR2(1) NOT NULL	Brokerage Fees Y/N Table Edit Default Value: N
10	BROKERAGE_CMSN_IND	Character(1)	VARCHAR2(1) NOT NULL	Brokerage Commission Y/N Table Edit Default Value: N
11	SEC_FEES_IND	Character(1)	VARCHAR2(1) NOT NULL	SEC Fees Y/N Table Edit Default Value: N