| NAMEPARTTYPECODE |
tinyint |
|
Default = 1 |
|
| NAMEPARTTYPE |
nvarchar(17) (Computed) |
yes |
CASE [NAMEPARTTYPECODE] WHEN 1 THEN N'Appeal code' WHEN 3 THEN N'Channel' WHEN 4 THEN N'Site' WHEN 5 THEN N'Due date' WHEN 6 THEN N'Launch date' WHEN 7 THEN N'Date created' WHEN 8 THEN N'Counter' WHEN 9 THEN N'Static identifier' WHEN 10 THEN N'Free-form' END |
|
| OPTIONTYPECODE |
tinyint |
|
Default = 0 |
|
| OPTIONTYPE |
nvarchar(10) (Computed) |
yes |
CASE [OPTIONTYPECODE] WHEN 0 THEN N'' WHEN 1 THEN N'#' WHEN 2 THEN N'0#' WHEN 3 THEN N'00#' WHEN 4 THEN N'000#' WHEN 5 THEN N'0000#' WHEN 6 THEN N'00000#' WHEN 7 THEN N'000000#' WHEN 8 THEN N'0000000#' WHEN 9 THEN N'00000000#' WHEN 10 THEN N'000000000#' WHEN 20 THEN N'YYYYMMDD' WHEN 21 THEN N'YYYY-MM-DD' WHEN 22 THEN N'YYYY/MM/DD' WHEN 23 THEN N'YYYYDDMM' WHEN 24 THEN N'YYYY-DD-MM' WHEN 25 THEN N'YYYY/DD/MM' WHEN 26 THEN N'YYMMDD' WHEN 27 THEN N'YY-MM-DD' WHEN 28 THEN N'YY/MM/DD' WHEN 29 THEN N'YYDDMM' WHEN 30 THEN N'YY-DD-MM' WHEN 31 THEN N'YY/DD/MM' WHEN 32 THEN N'YYYYMM' WHEN 33 THEN N'YYYY-MM' WHEN 34 THEN N'YYYY/MM' WHEN 35 THEN N'YYMM' WHEN 36 THEN N'YY-MM' WHEN 37 THEN N'YY/MM' WHEN 38 THEN N'YYYY' WHEN 39 THEN N'YY' WHEN 40 THEN N'YYYYMonth' WHEN 41 THEN N'YYYYMon' WHEN 42 THEN N'YYYY-Month' WHEN 43 THEN N'YYYY-Mon' WHEN 44 THEN N'YYMonth' WHEN 45 THEN N'YYMon' WHEN 46 THEN N'YY-Month' WHEN 47 THEN N'YY-Mon' WHEN 48 THEN N'MMDDYYYY' WHEN 49 THEN N'MM-DD-YYYY' WHEN 50 THEN N'MM/DD/YYYY' WHEN 51 THEN N'MMDDYY' WHEN 52 THEN N'MM-DD-YY' WHEN 53 THEN N'MM/DD/YY' WHEN 54 THEN N'MMYYYY' WHEN 55 THEN N'MM-YYYY' WHEN 56 THEN N'MM/YYYY' WHEN 57 THEN N'MMYY' WHEN 58 THEN N'MM-YY' WHEN 59 THEN N'MM/YY' WHEN 60 THEN N'MonthYYYY' WHEN 61 THEN N'MonthYY' WHEN 62 THEN N'Month-YYYY' WHEN 63 THEN N'Month-YY' WHEN 64 THEN N'MonYYYY' WHEN 65 THEN N'Mon-YYYY' WHEN 66 THEN N'MonYY' WHEN 67 THEN N'Mon-YY' WHEN 68 THEN N'DDMMYYYY' WHEN 69 THEN N'DD-MM-YYYY' WHEN 70 THEN N'DD/MM/YYYY' WHEN 71 THEN N'DDMMYY' WHEN 72 THEN N'DD-MM-YY' WHEN 73 THEN N'DD/MM/YY' END |
|
| VALUE |
nvarchar(100) |
|
Default = '' |
|
| SEPARATORTYPECODE |
tinyint |
|
Default = 0 |
|
| SEPARATORTYPE |
nvarchar(12) (Computed) |
yes |
CASE [SEPARATORTYPECODE] WHEN 0 THEN N<None> WHEN 1 THEN N<Space> WHEN 2 THEN N'- Hyphen' WHEN 3 THEN N'/ Slash' WHEN 4 THEN N'. Period' WHEN 5 THEN N', Comma' WHEN 6 THEN N'_ Underscore' WHEN 7 THEN N'* Asterisk' WHEN 8 THEN N': Colon' END |
|
| SEQUENCE |
int |
|
Default = 0 |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| COMMUNICATIONEFFORTVALUE |
nvarchar(100) |
|
Default = '' |
|