ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMAN
1
Excel to CI Template
2
4/3/2024
3
4
Please provide the Accounting Date:
(Must be in Current Period)
5
6
PLEASE DO NOT INSERT ANY INFORMATION IN THE GRAY COLUMNS BELOW. THEY WILL AUTOMATICALLY FILL WHEN CORRECT DATA IS ENTERED IN A COLUMN TO THE LEFT OF IT.
7
8
Rows 18 and 19 show the TYPE OF DATA THAT CAN BE ENTERED IN A COLUMN (character, numeric, or date):
9
Letters, numbers, and special characters
10
Numbers Only
11
Date only
12
Letters, numbers, and special characters. College decides the data/information to be entered
13
14
* MUST BE AN EXISTING LOCATION IN CTCLINK (CTC_AM_LOCATION_TBL)
15
~ Required Columns
CUSTODIAL DEPARTMENT/
PHYSICAL
16
INFORMATIONLOCATION
17
Data Item/Field NameInterface Line NumberBusiness UnitAsset IDOperating UnitFund CodeClass FieldProgram CodeState PurposeProjectDepartmentAsset CategoryCost TypeActivityTransaction DateIn Service DateQty InterfaceTotal CostFiscal YearStart PeriodEnd PeriodTransaction CostParent IDTaggable AssetTag NumberDescriptionShort DescriptionCapitalized AssetAcquisition DateAsset Profile IDManufacturer NameModelSerial ID*Manufacturing PlantAcquisition DetailTransaction AmountAmountQty InterfaceLocation CodeAsset Long Description
18
Data Item/Field Length8 Characters5 Characters12 Characters8 Characters5 Characters5 Characters5 Characters10 Characters15 Characters10 Characters5 Characters1 Character15 Character10 Date10 Date11 Numbers23 Numbers4 Numbers3 Numbers3 Numbers23 Numbers12 Characters1 Character12 Characters30 Characters10 Characters1 Character10 Date10 Characters60 Characters30 Characters20 Characters30 Characters30 Characters23 Numbers23 Numbers11 Numbers10 Characters254 Characters
19
Information it containsUnique %+ digit NumberWA + 3-digit college number~Unique tag number or identifier~"7" + 3-digit college number~Fund Code~Class Code~Program CodeAlways "N"~Project NumberDepartmental Code~(See Asset Category Options on 2nd Tab)~G or P (Governmental or Proprietary)~ActivityIn-service Date~In-service DateQuantity~Acquisition Cost~4-digit Fiscal Year~Typically Period "1"~Typically Period "12"~Acquisition CostParent Asset IDTaggable? Y or N~Unique Tag Number~Asset Description~Asset Short DescriptionCapitalized Asset (Y or N)?~Acquisition DateAsset Class/Profile ID (Options on 3rd Tab)~Manufacturer NameModel number or NameSerial NumberCustodial Department/ InformationDetermined by CollegeAcquisition CostAcquisition CostQuantityLocation Code*~Determined by College
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100