STOCK_IDPrompt Table: STOCK_TBL
ST_AGENCY_IDEFFDTST_CONTACT_TYPEA=Administrative
B=Broker
E=Escrow
T=Transfer
Y=Escrow/Transfer
Z=Administrative/Broker
LANGUAGE_CDST_AGNT_CT_LANG(SQL Table) |
Index Back |
|---|---|
Language Rcd for Agent ContactLanguage Record for Agent Contact |
| # | 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_AGENCY_ID |
Character(10) | VARCHAR2(10) NOT NULL | This field is used for Transfer Agents as well as Escrow Agents |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | ST_CONTACT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Contact Type
A=Administrative B=Broker E=Escrow T=Transfer Y=Escrow/Transfer Z=Administrative/Broker |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | COMMENTS | Long Character | CLOB | Comment |