Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| SpouseID | int | 4 | null |
|
|
|||
| SpouseFlag | bit | 1 | null |
|
|
|||
| MailNameJoint | varchar | 100 | null |
|
|
|||
| MailNamePrimary | varchar | 100 | null |
|
|
|||
| MailSalutationJoint | varchar | 100 | null |
|
|
|||
| MailSalutationPrimary | varchar | 100 | null |
|
|
|||
| AddressComma | varchar | 200 | √ | null |
|
|
||
| AddressFull | varchar | 200 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | √ | null |
|
|
||
| AddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| AddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| AddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| PastParentFlag | varchar | 1 | null |
|
|
|||
| CurrentParentFlag | varchar | 1 | null |
|
|
|||
| DebtorFlag | varchar | 1 | null |
|
|
|||
| CreditorFlag | varchar | 1 | null |
|
|
|||
| FutureParentFlag | varchar | 1 | null |
|
|
|||
| PastStudentFlag | varchar | 1 | null |
|
|
|||
| PastStudentPeerYear | smallint | 2 | null |
|
|
|||
| PastStudentLeftYear | int | 4 | null |
|
|
|||
| StaffFlag | varchar | 1 | null |
|
|
|||
| InactiveStaffFlag | varchar | 1 | null |
|
|
|||
| FriendOnlyFlag | varchar | 1 | null |
|
|
|||
| DonorFlag | varchar | 1 | null |
|
|
|||
| DonorPledgesOutstanding | money | 21,4 | null |
|
|
|||
| DonorReceipts | money | 21,4 | null |
|
|
|||
| RelatedCampus | varchar | 3 | null |
|
|
Table contained 0 rows