Stored Procedure Names
The name of the stored procedure should follow this format:
spLocal_CCCSSSTTTDDDD. Where,
CCC = Corporation (for example, GED for GE Digital)
SSS = Site (for example, ‘TO’ for Toronto) or ‘Cmn’ for globally reused stored procedures
TTT = Type of stored procedure (for example, ‘Calc’ for variable calculations or ‘Rpt’ for reports)
DDDD = Details of the stored procedure (for example, ‘Availability’ for an OEE calculation)
There is no restriction on the size of the abbreviation or the number of characters to use for each clause. The following is a list of common types that can be reused:
| Abbreviation | Description |
|---|---|
| PE | Production event model |
| ME | Movement event model |
| UDE | User-defined event model |
| Calc | Variable calculation |
| Rpt | Report |
| SDK | Stored procedure called from SDK via ExecuteCommand or ExecuteSQL |
| WEBS | Stored procedure call from a web service |
| WEBD | Stored procedure called from a web dialog (for example, asp page) |
| IF | Interface stored procedure |