VACOLS Data Dictionary

	A	B	C	D	E	F	H
1	DO NOT UPDATE THIS. EDIT https://department-of-veterans-affairs.github.io/caseflow/task_trees/schema/vacols_schema.html instead
2	VACOLS Data Dictionary		Last Updated: July 12, 2016			Oracle 11.2.0.3.0 Database	Our notes
3	TABLE NAME	FIELD DESCRIPTION	FIELD NAME	TYPE	SIZE	RELATED TABLES/REMARKS

4	ASSIGN	(Diary Table)
32
33	ATTACH	(Attachments table)
53
54	BRIEFF	(Briefface table)
139
140	CORRES	(Veteran/Appellant table)
196	CORRTYPS	Primary key	CTYPKEY	VARCHAR2	16	Corres(stafkey)
204
205	COVA
230
231	FOLDER
294
295	HEARSCHED
330
331	ISSREF
342
343	ISSUES
362
363	MAIL
402
403
404	PRIORLOC
414
415	OTHDOCS
440
441	RMDREA
449
450	REP
475
476
477	STAFF
525
526	VFTYPES
539
540	COIN
567
568	DECREVIEW
617
618	ACTCODE
634
635
636	DECASS
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729