|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimStudentReceipt |
| Database Table Name | DimStudentReceipt |
| Schema | dbo |
| Friendly Name | DimStudentReceipt |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
StudentReceiptSK |
StudentReceiptSK |
System.Int32 | ||
 |
StudentReceiptAK |
StudentReceiptAK |
System.String(24) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
PrintedReceiptNumber |
PrintedReceiptNumber |
System.Int32 | ||
|
ReceiptCategory |
ReceiptCategory |
System.String(15) | ||
|
ReceiptProcesserCode |
ReceiptProcesserCode |
System.String(8) | ||
|
ReceiptProcesser |
ReceiptProcesser |
System.String(50) | ||
|
SessionDate |
SessionDate |
System.DateTime | ||
|
SessionSequenceNumber |
SessionSequenceNumber |
System.Int32 | ||
|
ReceiptSequenceNumber |
ReceiptSequenceNumber |
System.Int32 | ||
|
ReceiptTypeCode |
ReceiptTypeCode |
System.String(3) | ||
|
ReceiptType |
ReceiptType |
System.String(30) | ||
|
MiscellaneousReceiptCatecoryCode |
MiscellaneousReceiptCatecoryCode |
System.String(3) | ||
|
MiscellaneousReceiptCategory |
MiscellaneousReceiptCategory |
System.String(30) | ||
|
ReceiptReference |
ReceiptReference |
System.String(30) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
StudentReceiptSK |
FactStudentReceiptTotals |
Table |
False |
||
StudentReceiptSK |
FactStudentReceiptPayments |
Table |
False |
| Powered by BI Documenter |
