| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQNOTECODTEXT | Note Text for Predefined Notes | 3 | NOTETYPE | Note Type | nvarchar | 4 | 0 | | |
2 | T7PIQNOTETYPEADV | Advisory notes | 2 | NOTETYPE | Note Type | nvarchar | 4 | 0 | | |
3 | T7PIQNOTETYPES | Note Types | 2 | NOTETYPE | Note Type | nvarchar | 4 | 0 | | |
4 | T7PIQ_US_SEVNM | SEVIS SPECIFIC NOTES MAPPED | 2 | NOTETYPE | SEVIS: Note Type | nvarchar | 2 | 0 | | |
5 | T7PIQ_US_SEVNO | Define SEVIS Note Types | 2 | NOTETYPE | SEVIS: Note Type | nvarchar | 2 | 0 | | |
6 | T7PIQ_US_SEVNOT | SEVIS Notes for comments/Descriptions | 3 | NOTETYPE | SEVIS: Note Type | nvarchar | 2 | 0 | | |
TOPClaims Management |
7 | ICLNOTE | Claim Note | 10 | NOTETYPE | Topic of Claim Note | nvarchar | 2 | 0 | | |
8 | ICL_CNOTE_TYPE | Internal Claim Type: Permitted Topic of Claim Note | 6 | NOTETYPE | Topic of Claim Note | nvarchar | 2 | 0 | | |
9 | ICSNOTE | Note | 10 | NOTETYPE | Topic of Claim Note | nvarchar | 2 | 0 | | |
10 | TICL090 | Topic of Claim Note | 2 | NOTETYPE | Topic of Claim Note | nvarchar | 2 | 0 | | |
11 | TICL090T | Topic of Claim Note | 3 | NOTETYPE | Topic of Claim Note | nvarchar | 2 | 0 | | |
TOPImplementation Guide |
12 | TNONOCL | Project class node type note type assignment | 4 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
13 | TNOTECL | Project class note type assignment | 2 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
14 | TNOTEEPR | Project management note types | 1 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
15 | TNOTEFPR | Assignment of file extensions to doc. types | 1 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
16 | TNOTEP | Project note type | 2 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
17 | TNOTESAV | Note document temporary save | 4 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
18 | TNOTETEM | Templates for notes | 1 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
19 | TNOTETPR | Project management: Note type text | 2 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
20 | TNOTFPR | Notes: Project link | 4 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
TOPSolution Manager Implementation |
21 | SADOCATTRIBUTES | Solution Manager: Hidden Document Attributes | 1 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |
22 | SADOCMANDATORATT | Solution Manager: Obligatory Document Attributes | 1 | NOTETYPE | Valid Document Types | nvarchar | 4 | 0 | | |