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 |
|