DOCUMENT CONTROL DATA DICTIONARY (Sybase)
DOCUMENT CONTROL DATA DICTIONARY (Sybase)
TABLE NAMES All table names are identified by two words separated by the under score and
and the first character is capitalized. (e.g.:Item_master).
PART_NO Field length is 16 characters; user will only see 13 for part_no;last 4 chars for #of files.
See SMA Part Specification for more details.
If you have any comments or questions regarding this specification send email to pmailhot@cfa.harvard.edu
Last update: Auguest 8, 1996
TOPIC DEFINITIONS
Custom Stored Procedures/Triggers are not available thru the Web. Contact
pmailhot@cfa.harvard.edu
SMA USED ON GENERATED
DEFAULTS TABLE FROM FIELD DESCRIPTION
defcur_date Item_master date_issued Inputs system date and time
defunit_meas Item_master unit_meas "EA"
defstd_cost Item_master unit_price "0.0"
defhardcp_size Config_tbl hardcp_size "A" A size dwg.
defrev_level Item_master part_rev "00"
Note: Some defaults are incorporated at the GUI level (eg: Class_code = "P").
INDEXES
TABLE FIELD NAME
Config_tbl part_no i_partno Unique index.
Single_bom assy_no i_assyno index
Single_bom comp_no i_compno index
Item_master part_no i_partno Unique index.
PRIMARY FIELDS FOR EACH TABLE
TABLE FIELD
Item_master part_no (Primary table for database)
Config_tbl part_no
Single_bom assy_no
Single_bom comp_no
Manufact_id mfg_id
Vendor_id vendor_id
Eco_tbl part_no
Inventory_cntrl part_no
Pur_item po_no
Pur_fund req_no
FIELD CODE DEFINITIONS
TABLE FIELD DEFINITIONS
Item_master class_code A = Assembly Document
Item_master class_code P = Purchase Piece Part
Item_master class_code F = Fabricated Part
Item_master class_code D = Reference Document
Item_master class_code R = Reference Number (NO Documentation)
Item_master class_code T = Tooling Document
Name Owner Object_type
--------------- --------------- ----------------------
Doc_backup dbo user table
Dump_test dbo user table
ECO_log dbo user table
File_history dbo user table
File_storage dbo user table
File_store dbo user table
H_S_Config dbo user table
Inventory_cntrl dbo user table
Item_master dbo user table
Mfg_id dbo user table
PO_log dbo user table
Pur_fund dbo user table
Pur_fund_00 dbo user table
Pur_item dbo user table
SMA_equip dbo user table
Single_BOM dbo user table
Vendor_id dbo user table
eco_parts dbo user table
User Tables
Name Owner Type
------------------------------ ------------------------------ ----------------------
Doc_backup dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Dec 29 1995 10:00AM
Column_name Type Length
--------------- --------------- ------
backup_no char 7
backup_date datetime 8
backup_by char 10
backup_loc char 10
backup_type char 10
backup_dir text 16
Name Owner Type
------------------------------ ------------------------------ ----------------------
Dump_test dbo user table
Table used to verifiy database backups.
Data_located_on_segment When_created
------------------------------ --------------------------
default Apr 24 1996 3:49PM
Column_name Type Length
--------------- --------------- ------
data_dump01 char 16
data_dump02 char 2
DATA SAMPLE:
data_dump01 data_dump02
---------------- -----------
trash_here 00
trash_also 10
delete_this 20
and_this 30
more_trash 40
Name Owner Type
------------------------------ ------------------------------ ----------------------
ECO_log dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Dec 6 1995 4:06PM
Column_name Type Length
--------------- --------------- ------
eco_no int 4
orig_eng char 15
primary_pn char 16
to_part_rev char 2
fr_part_rev char 2
eng_dept varchar 10
reason_chg varchar 100
descrip_chg text 16
date_orig datetime 8
date_comp datetime 8 defdate_comp
eco_parts_tbl char 2
eco_status varchar 15
index_name index_description index_keys
-------------------- ----------------- ---------------------
ieco_no clustered, unique located on default eco_no
DATA SAMPLE:
126 MCCRACKEN 11704540000 0A 0B MECHANICAL
The mounting holes need top be on the drawing, the unnecessary flexible boot details were removed, a
Added the mounting hole positions and dimensions to the flanges, the flexible boot detail was removed, and the
references to incorrect thicknesses were removed.
Jan 1 1999 12:00AM Jan 1 1999 12:00AM Y
COMPLETE
Name Owner Type
------------------------------ ------------------------------ ----------------------
File_history dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default May 15 1996 1:29PM
Column_name Type Length
--------------- --------------- ------
fs_history_code varchar 15
fs_appli varchar 10
fs_appli_rev varchar 5
fs_opr_sys varchar 5
fs_opr_sys_rev varchar 5
index_name index_description index_keys
-------------------- ----------------- ---------------------
ihist_code clustered, unique located on default fs_history_code
DATA SAMPLE:
fs_history_code fs_appli fs_appli_rev fs_opr_sys fs_opr_sys_rev
--------------- ---------- ------------ ---------- --------------
AUTOSKTCH/DOS AUTOSKTCH 3.0 DOS 6.X
CAD/DOS PCBinary 0.0 DOS 6.X
ENVISIONTI/DOS ENVISION T 3.0 DOS 6.X
Name Owner Type
------------------------------ ------------------------------ ----------------------
File_storage dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default May 24 1996 11:42AM
Column_name Type Length
--------------- --------------- ------
fs_part_no varchar 16
fs_part_rev varchar 2
fs_bytesize int 4
fs_format varchar 10
fs_page_no smallint 2
fs_history_code varchar 15
fs_notes varchar 30
DATA SAMPLE:
fs_part_no fs_part_rev fs_bytesize fs_format fs_page_no fs_history_code fs_notes
---------------- ----------- ----------- ---------- ---------- --------------- ------------------------
11701310000 A 110235 ASC 1 IDEAS/IRX Mechanical Dwg
11701310000 B 64889 ASC 1 IDEAS/IRX Mechanical Dwg
Name Owner Type
------------------------------ ------------------------------ ----------------------
File_store dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Jan 22 1996 1:56PM
Column_name Type Length
--------------- --------------- ------
fs_part_no char 16
fs_no_pages smallint 2
fs_part_rev char 2
fs_file image 16
fs_bytesize int 4
fs_history_code smallint 2
fs_notes varchar 30
Name Owner Type
------------------------------ ------------------------------ ----------------------
H_S_Config dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Nov 22 1995 9:41AM
Column_name Type Length
--------------- --------------- ------
mnemonic_name varchar 16
mne_part_no char 16
mne_part_rev char 2
mne_ref_desg varchar 30
mne_type char 5
pin_no smallint 2
rtn_no smallint 2
sch_name varchar 20
mne_description varchar 50
mne_signal char 6
mne_max float 8
mne_min float 8
mne_nom float 8
mne_unit_meas char 2
mne_priority char 6
mne_destination varchar 16
mne_comments varchar 2
mne_cable_no varchar 2
Name Owner Type
------------------------------ ------------------------------ ----------------------
Inventory_cntrl dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Jul 2 1996 9:59AM
Column_name Type Length
--------------- --------------- ------
part_no char 16
part_camb01 float 8
part_camb02 float 8
part_hays01 float 8
part_hawi01 float 8
mfg_serial_no varchar 20
smaid_no varchar 20
last_po_no varchar 15
lab_notes varchar 50
Name Owner Type
------------------------------ ------------------------------ ----------------------
Item_master dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Oct 3 1995 10:10AM
Data_located_on_segment When_created
------------------------------ --------------------------
default Jul 1 1996 2:19PM
Column_name Type Length
--------------- --------------- ------
part_no char 16
part_title varchar 50
unit_meas char 2 defunit_meas
class_code char 1
mfg_no_01 char 30
mfg_no_02 char 30
mfg_no_03 char 30
orig_name char 15
old_partno char 16
date_issued datetime 8
index_name index_description index_keys
-------------------------------------------------------------
iPart_no nonclustered,
unique located on default part_no
DATA SAMPLE:
part_no part_title unit_meas class_code mfg_code orig_name ld_partno date_issued
------------ ---------------------------------------- ---------
11701310000 MECH FAB AZIMUTH ENCODER COVER EA F 50944 MCCRACKEN NEW Dec 4 1994 12:00AM
Name Owner Type
------------------------------ ------------------------------ ----------------------
Mfg_id dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Dec 6 1995 10:19AM
Column_name Type Length
--------------- --------------- ------
mfg_name varchar 35
mfg_code char 6
mfg_contact varchar 20
mfg_street varchar 40
mfg_city varchar 20
mfg_state char 2
mfg_zip char 10
Name Owner Type
------------------------------ ------------------------------ ----------------------
PO_log dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Dec 6 1995 11:27AM
Column_name Type Length
--------------- --------------- ------
pur_reqno char 15
vendor_code char 6
mfg_code char 6
part_no char 16
unit_price money 8
qty_req float 8
qty_recd float 8
date_orig datetime 8
date_req datetime 8
date_recd datetime 8
Name Owner Type
------------------------------ ------------------------------ ----------------------
Pur_fund dbo user table
Data is downloaded from Purchasing Database (SAO/VAX).
Data_located_on_segment When_created
------------------------------ --------------------------
default Mar 25 1996 10:53AM
Column_name Type Length
--------------- --------------- ------
freq_number char 10
date_in datetime 8
fpo_number char 9
date_place datetime 8
vend_name char 21
date_recd datetime 8
dis money 8
stat_code char 2
fund_no char 9
program char 7
org_no char 5
class char 4
buyer char 3
change_ord char 3
del_date datetime 8
req_value money 8
vend_code char 6
vend_type char 2
award_type char 4
DATA SAMPLE:
AF2488 Jun 17 1994 12:00AM SA431839 Jun 21 1994 12:00AM
L.E. MURAN CO. Jun 23 1994 12:00AM
397.15 C 8A400000 P12R37 4R60 260
RC Jun 24 1994 12:00AM 537.67
S COM
Name Owner Type
------------------------------ ------------------------------ ----------------------
Pur_item dbo user table
Data is downloaded from Purchasing Database (SAO/VAX).
Data_located_on_segment When_created
------------------------------ --------------------------
default Mar 25 1996 2:15PM
Column_name Type Length
--------------- --------------- ------
po_number char 10
req_number char 10
date_in datetime 8
req_by char 36
date_placed datetime 8
vend_name char 21
stat_code char 2
po_value money 8
item_no char 3
description char 55
qty float 8
unit char 5
price money 8
note char 17
date_logd datetime 8
DATA SAMPLE:
SA533718 AF4391 May 1 1995 12:00AM
LOUIE LEOMBRUNO May 4 1995 12:00AM
MELCOR CORPORATION C 0.00 5
THERMOELECTRIC COOLER CP-1.4-127-10L
3.000000 EA 26.00
Jan 1 1900 12:00AM
SA533799 AF4468 May 16 1995 12:00AM
EDWARD TONG May 16 1995 12:00AM
INTERNATIONAL MFG. S C 0.00 1
Chip Resistor #RC0603 1% tol. - 49.9 ohms
30.000000 pc 1.00
Jan 1 1900 12:00AM
Name Owner Type
------------------------------ ------------------------------ ----------------------
SMA_equip dbo user table
Data is downloaded from Procurement Ofc/SAO Serial Numbers Database (VAX).
Data_located_on_segment When_created
------------------------------ --------------------------
default Apr 26 1996 10:44AM
Column_name Type Length
--------------- --------------- ------
SI_tag_no char 14
sma_part_no char 16
po_no char 11
organ_no char 5
si_location char 3
group_code char 3
description char 30
si_vend_name char 15
mfg_serial_no varchar 25
source_code char 1
fund_no char 10
com_code char 3
sma_loc char 10
rep_code char 1
po_value money 8
old_tag char 14
rec_lab datetime 8
hawaii_loc_01 datetime 8
hawaii_loc_02 datetime 8
cambridge datetime 8
haystack datetime 8
other char 10
comments char 30
DATA SAMPLE:
237004 0 SA4-30654 4R60 82 RN
CHASSIS,1401A,C-SIZE HEWPACK
3227A02566 3 8A400040 321 M-109
1 5,474.50 N/A
Apr 1 1996 12:00AM Apr 1 1996 12:00AM
Apr 1 1996 12:00AM Apr 1 1996 12:00AM
Apr 1 1996 12:00AM N/A N/A
Name Owner Type
------------------------------ ------------------------------ ----------------------
Single_BOM dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Jun 20 1995 9:36AM
Column_name Type Length
--------------- --------------- ------
assy_no char 16
item_no smallint 2
comp_no char 16
qty_recd float 4
ref_desg varchar 30
keytype object related_object object_keys related_keys
---------- ------------------------------ ------------------------------
----------------------------------------------------------------------
----------------------------------------------------------------------
primary Single_BOM -- none --
assy_no, comp_no, *, *, *, *, *, *
*, *, *, *, *, *, *, *
DATA SAMPLE:
10367140001 0 SMA_ASSEMBLY 0.000000 N/A
10367140001 1 10267350001 1.000000 A1
10367140001 2 10267360001 4.000000 A2,A3,A4,A5
10367140001 3 10267370001 4.000000 A6,A7,A8,A9
10367140001 4 10267380001 1.000000 A10
Name Owner Type
------------------------------ ------------------------------ ----------------------
Vendor_id dbo user table
Data_located_on_segment When_created
------------------------------ --------------------------
default Dec 6 1995 10:27AM
Column_name Type Length
--------------- --------------- ------
Vendor_name varchar 35
Vendor_code char 6
Vendor_contact varchar 20
Vendor_street varchar 40
Vendor_city varchar 20
Vendor_state char 2
Vendor_zip char 10