ctcLink Reference CenterCampus Community Service Indicators 11CS General Naming Conventions (Service Indicators) 11g

CS General Naming Conventions (Service Indicators) 11g

A shared CS naming convention is recommended in order to facilitate the naming of various shared items in the system. In particular, service indicators, standard letter codes, communications contexts, checklist items and codes and comment categories are all examples of things that are shared across CS modules that would benefit from using a naming convention

The following object names fall under the Tech naming standards, Reference the document from the Tech Lead -

  • Equation engine names (length 12)
  • Query Names (length 35)  CTC_XX where XX denotes the module
  • Report Definitions (length 12) -
  • Datasources  (length 35)
  • Templates (length 35+)
  • Jobs (length 8)
  • Jobsets (length 30)

The following table introduces a recommended naming convention:

Naming Convention table below.

1st Position School Abbreviation
2nd-3rd Position
4th to 9th Positions Admin Offices, Dept assigned to first code DO NOT USE
A
A-Z, 0-9 Admissions ACQ, ANO
B
A-Z, 0-9
Bursar
C
A-Z, 0-9
Bursar CAN, CBR, CTR
D
A-Z, 0-9
Bursar DEP, DIV
E
A-Z, 0-9
Financial Aid - Even Year
F
A-Z, 0-9
Financial Aid - Odd Year FAN
G
A-Z, 0-9
Academic Advising
H
A-Z, 0-9
Academic Advising
I
A-Z, 0-9

IR, IS1, IS2, IS3
J
A-Z, 0-9
Financial Aid - Even Year
K
A-Z, 0-9
Financial Aid - Odd Year
L
A-Z, 0-9
Financial Aid - Even Year
M
A-Z, 0-9
Financial Aid - Odd Year
N
A-Z, 0-9
Financial Aid - Even Year
O
A-Z, 0-9


P
A-Z, 0-9
Financial Aid - Odd Year
Q
A-Z, 0-9
Financial Aid - Even Year
R
A-Z, 0-9
Student Records (Reporting) REV, RSC
S
A-Z, 0-9
Student Records (also for SBCTC defined student groups only)
T
A-Z, 0-9
Student Records (Worker Re Training)
U
A-Z, 0-9


V
A-Z, 0-9
Student Records (Veterans)
W
A-Z, 0-9
Financial Aid Odd
X
A-Z, 0-9
Financial Aid Even
Y
A-Z, 0-9
Financial Aid Odd
Z
A-Z, 0-9
Admissions

College Code table below.

COLLEGE 2 DIGIT CODE 1 CHAR CODE
Bates TC BA A
Bellevue College BV B
Bellingham TC BH C
Big Bend CC BB D
Cascadia CC CC E
Centralia College CN F
Clark College CL G
Clover Park TC CP H
Columbia Basin CB I
Edmonds CC ED J
Everett CC EV K
Grays Harbors CC GH L
Green River GR M
Highline HL N
Lake Washington IT LW O
Lower Columbia LC P
North Seattle  NS Q
Olympic OL R
Peninsula PE S
Pierce PI T
Renton TC RE U
Seattle Central SC V
Seattle Vocational Inst VI W
Shoreline SH X
Skagit Valley SK Y
South Puget Sound CC SO Z
South Seattle CC SS 1
Spokane SP 2
Tacoma CC TC 3
Walla Walla  WW 4
Wenatchee Valley WN 5
Whatcom WH 6
Yakima Valley CC YV 7
State Board SB 8

Examples:

  • Three Positions
    • Letter Codes, Service Indicators
    • Examples:
  • Four Positions
    • 3 C Groups, Comments Category, Student Groups
    • Examples:  
  • Five Positions
    • Communication Category (contains inst)
    • Examples:
  • Six Positions
    • Communication Context (contains inst), Checklist Code (contains inst), Checklist Item (even/odd)
    • Examples:
      • Checklist items: module + college + meaningful text
  • Eight Positions
    • Speedkeys
    • Example:
      • Letter code + ‘SK’
  • Ten Positions
    • Event IDs (even/odd)
    • Example:
      • Module + EV or OD + informative text
  • Twelve Positions (Equation Engines, Report Definitions  See the Tech naming standards)
  • Long names
    • Map Names   CTC_FA_SC
      • FA being the module abbreviation
      • SC stands for the 2 character school code in the above table
      • This will make it easier for IT to copy from one database to another.

Financial Aid Letter Codes table below.

Financial Aid Letter Codes Logic

288 FA Letter Code combinations per Institution
1st character consists of E,F,L,M,J,K,N or P based on the institution (see institution abbreviation chart above). The first value would be used for “even award year” or non-aid year specific processing, while the second value would be used for “odd award year” processing.

1ST CHARACTER

2ND CHARACTER

3RD CHARACTER

BV

E or F

SL

L or M

GR

J or K

CC

N or P

0,1,2,3

0 – 9, then A - Z

BB

E or F

SK

L or M

HL

J or K

BA

N or P

4,5,6,7

0 – 9, then A - Z

CN

E or F

SP

L or M

LC

J or K

BH

N or P

8,9,A,B

0 – 9, then A - Z

CL

E or F

SF

L or M

PU

J or K

CP

N or P

C,D,E,F

0 – 9, then A - Z

CB

E or F

TC

L or M

OL

J or K

LW

N or P

G,H,I,J

0 – 9, then A - Z

ED

E or F

WW

L or M

PE

J or K

RE

N or P

K,L,M,N

0 – 9, then A - Z

EV

E or F

WN

L or M

SC

J or K

VI

N or P

O,P,Q,R

0 – 9, then A - Z

PI

E or F

WH

L or M

NS

J or K

SB

N or P

S,T,U,V

0 – 9, then A - Z

GH

E or F

YK

L or M

SS

J or K


W,X,Y,Z

0 – 9, then A - Z


College Codes table below.

College 1st Char
(FA Module:  E, F, L, M, J, K, N, P)
2nd Char
(School)
3rd Char
(Sequential)
Bates N or P 4, 5, 6, 7 0-9, then A-Z
Bellevue College E or F 0, 1, 2, 3 0-9, then A-Z
Bellingham TC N or P 8, 9, A, B 0-9, then A-Z
Big Bend CC E or F 4, 5, 6, 7 0-9, then A-Z

Cascadia CC N or P 0, 1, 2, 3 0-9, then A-Z
Centralia College E or F 8, 9, A, B 0-9, then A-Z
Clark College E or F C, D, E, F 0-9, then A-Z
Clover Park TC N or P C, D, E, F 0-9, then A-Z
Columbia Basin E or F G, H, I, J 0-9, then A-Z
Edmonds CC E or F K, L, M, N 0-9, then A-Z
Everett CC E or F O, P, Q, R 0-9, then A-Z
Grays Harbor CC E or F W, X, Y, Z 0-9, then A-Z
Green River J or K 0, 1, 2, 3 0-9, then A-Z
Highline J or K 4, 5, 6, 7 0-9, then A-Z
Lake Washington IT N or P G, H, I, J 0-9, then A-Z
Lower Columbia J or K 8, 9, A, B 0-9, then A-Z
North Seattle J or K S, T, U, V 0-9, then A-Z
Olympic J or K G, H, I, J 0-9, then A-Z
Peninsula J or K K, L, M, N 0-9, then A-Z
Pierce E or F S, T, U, V 0-9, then A-Z
Renton TC N or P K, L, M, N 0-9, then A-Z
Seattle Central  J or K O, P, Q, R 0-9, then A-Z
Seattle Vocational Institute N or P O, P, Q, R 0-9, then A-Z
Shoreline  L or M 0, 1, 2, 3 0-9, then A-Z
Skagit Valley L or M 4, 5, 6, 7 0-9, then A-Z
South Puget Sound CC J or K C, D, E, F 0-9, then A-Z
Spokane CC L or M 8, 9, A, B 0-9, then A-Z
Spokane Falls L or M C, D, E, F  0-9, then A-Z
Tacoma CC L or M G, H, I, J 0-9, then A-Z
Walla Walla L or M K, L, M, N 0-9, then A-Z
Wenatchee Valley L or M O, P, Q, R 0-9, then A-Z
Whatcom L or M S, T, U, V 0-9, then A-Z
Yakima Valley CC L or M W, X, Y, Z 0-9, then A-Z

College Codes table below

College
1st Char
(Module B, C, D belongs to SF)
2nd Char
(School)
3rd Char
(Sequential)
Bates TC B-D A 0-Z
Bellevue College B-D
B 0-Z
Bellingham TC B-D
C 0-Z
Big Bend CC B-D
D 0-Z
Cascadia CC B-D
E 0-Z
Centralia College B-D
F 0-Z
Clark College B-D
G 0-Z
Clover Park TC B-D
H 0-Z
Columbia Basin B-D
I 0-Z
Edmonds CC B-D
J 0-Z
Everett CC B-D
K 0-Z
Grays Harbor CC B-D
L 0-Z
Green River B-D
M 0-Z
Highline B-D
N 0-Z
Lake Washington IT B-D
O 0-Z
Lower Columbia B-D
P 0-Z
North Seattle B-D
Q 0-Z
Olympic
B-D
R 0-Z
Peninsula B-D
S 0-Z
Pierce B-D
T 0-Z
Renton TC B-D
U 0-Z
Seattle Central B-D
V 0-Z
Seattle Vocational Inst B-D
W 0-Z
Shoreline B-D
X 0-Z
Skagit Valley B-D
Y 0-Z
South Puget Sound CC B-D
Z 0-Z
South Seattle CC B-D
1 0-Z
Spokane CC B-D
2 0-Z
Spokane Falls B-D
3 0-Z
Tacoma CC B-D
4 0-Z
Walla Walla B-D
5 0-Z
Wenatchee Valley B-D
6 0-Z
Whatcom B-D
7 0-Z
Yakima Valley CC B-D
7
0-Z

College 3 Character Abbreviation table below

College 3 Char Abbreviation
Bates TC BAT
Bellevue College BEL
Bellingham TC BTC
Big Bend CC BBC
Cascadia CC CAS
Centralia College CEN
Clark College CLK
Clover Park TC CPT
Columbia Basin CBC
Edmonds CC ECC
Everett CC EVC
Grays Harbor CC GHC
Green River GRC
Highline  HLC
Lake Washington IT LWI
Lower Columbia  LCC
North Seattle NSC
Olympic OLC
Peninsula PEN
Pierce PIE
Renton TC RTC
Seattle Central SCN
Seattle Vocational Inst
Shoreline SHC
Skagit Valley SVC
South Puget Sound CC SSC
South Seattle SSC
Spokane CC SCC
Spokane Falls SFC
Tacoma CC TCC
Walla Walla WWC
Wenatchee Valley WVC
Whatcom WCC
Yakima Valley CC YVC

0 Comments

Add your comment

E-Mail me when someone replies to this comment