FACT_RECURRINGGIFTINSTALLMENTPAYMENT_STAGE
Contains information about recurring gift installment payments.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| RECURRINGGIFTINSTALLMENTPAYMENTSYSTEMID | uniqueidentifier | yes | [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[ID] | |
| RECURRINGGIFTINSTALLMENTSYSTEMID | uniqueidentifier | yes | [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[RECURRINGGIFTINSTALLMENTID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| SOURCEDIMID | int | yes | Source system used. | |
| RECURRINGGIFTINSTALLMENTPAYMENTSEQUENCE | int | yes | The sequence of recurring gifts payment splits. The ETL will only take the first one. | |
| REVENUEAPPLICATIONSYSTEMID | uniqueidentifier | yes | dbo.[FINANCIALTRANSACTIONLINEITEM].[ID] | |
| RECURRINGGIFTINSTALLMENTPAYMENTAMOUNT | money | yes | [dbo].[RECURRINGGIFTINSTALLMENTPAYMENT].[AMOUNT] | |
| ACTIVITYTYPE | nvarchar(8) | yes | [dbo].[RECURRINGGIFTACTIVITY].[TYPE] |