Table Definition- tFMSSystems

Table Definition- tFMSSystems
Field Name	Field Type	Field Size	Sample Data
FMSSystemID	int	4	1
AgencyID	int	4	2
FY	char	4	1998
Active	varchar	3	Yes
MarkComplete	datetime	16	2/9/1946
AgencyBureauCode	varchar	255	AID/G/HCD
Agency	varchar	255	AID
Bureau	varchar	255	G/HCD
SubBureau	varchar	255
OMBIndicator	varchar	255	R
SystemAcronym	varchar	255	W-251
SystemName	varchar	255	Participant Training Management System
ApplicationReference	varchar	255	W-251
ApplicationName	varchar	255	Participant Training Management Sys
Description	varchar	1500	PC-based systems to track training participants
ApplicationType	varchar	255	Y
ApplicationTypeLong	varchar	255
TypeOther	varchar	255
FMIndicator	varchar	255	M
FuncGL	varchar	255
FuncBE	varchar	255
FuncFC	varchar	255
FuncAP	varchar	255
FuncDB	varchar	255
FuncRAR	varchar	255
FuncDP	varchar	255
FuncCA	varchar	255
FuncBF	varchar	255
FuncRP	varchar	255
FuncCP	varchar	255
FuncMP	varchar	255
FuncPR	varchar	255
FuncTA	varchar	255
FuncLD	varchar	255
FuncTN	varchar	255	X
FuncTR	varchar	255
FuncPC	varchar	255
FuncIN	varchar	255
FuncSA	varchar	255
FuncPP	varchar	255
FuncRM	varchar	255
FuncGM	varchar	255
FuncDL	varchar	255
FuncGU	varchar	255
FuncSE	varchar	255
FuncSU	varchar	255
FuncMG	varchar	255
FuncIV	varchar	255
FuncMI	varchar	255
FuncOther	varchar	255
FuncALL	varchar	1000	Train
FuncALLLong	varchar	1000
ContactOrganization	varchar	255	Office of International Training
ContactPerson	varchar	255	Hugh Maney
ContactPhone	varchar	255	(202) 712-4141
ContactEmail	varchar	255
ApplicationStatus	varchar	255	OPERATIONAL
FuturePlans	varchar	255	R
Replacement	varchar	255	HCD/IRM
EndLife	int	4	1997
ImplementationDate	varchar	255	Sep 30 1986 12:00AM
LastUpgrade	varchar	255	Sep 30 1993 12:00AM
Remediate	varchar	255
Year2KStatus	varchar	255	A
DepartmentStandard	varchar	255	N
SIFMS	varchar	255
FMFIAConformance	varchar	255
JFMIPCompliance	varchar	255	A
AccountingStandardsCompliance	varchar	255	U
StandardDataClassificationUsed	varchar	255	A
SGL	varchar	255	NOTAPPL
ExternalReport	varchar	255	P
InternalReport	varchar	255	P
Process	varchar	255	P
OffTheShelf	varchar	255
Custom	varchar	255	X
ITStandards	varchar	255	O
ITStandardsDate	varchar	255	Dec 1 1981 12:00AM
UserOfServices	varchar	255	NA
Source	varchar	255	Developed by contractor for AID-NK
ProviderOfServices	varchar	255	NA
NumberServed	numeric	19	0
TransactionVolume	numeric	19	101746
TechnicalEnvironment	varchar	255	PC DOS FOXBASE
Mainframe	varchar	255
MidRange	varchar	255
ClientServer	varchar	255
PersonalComputer	varchar	255	X
CardService	varchar	255
Internet	varchar	255
Manual	varchar	255
OtherEnvironment	varchar	255
OtherEnvironmentExplanation	varchar	255
TechnicalEnvironmentIndicatorsALL	varchar	255	PersonalComputer
TEIALLLong	varchar	1000
Char1	varchar	255
Char2	varchar	255
Num1	varchar	255	0
Num2	varchar	255	0
VersionNumber	varchar	50
ThirdPartyProduct	varchar	255
EstNumberUsers	varchar	50
EstFederalFTE	varchar	50
CreatedAt	datetime	16	6/24/2001 11:59:20 PM
CreatedBy	varchar	255	Import
ChangedAt	datetime	16
ChangedBy	varchar	255
ITCode	varchar	255
PrevFYId	int	4	0
Comments	varchar	255
PRContact	varchar	255
PRPhone	varchar	255
Archive	varchar	3	No
IT53AgencyCode	varchar	3	184
IT53BureauCode	varchar	2
IT53Area	varchar	2
IT53Mission	varchar	2
IT53Type	varchar	2
IT53SpecificID	varchar	4
IT53Status	varchar	2
IT53FEABusinessArea	varchar	3
IT53FEASubFunction	varchar	3