Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
|
| PREREQUISITE_ID | int | 4 | √ | null |
|
|
Prerequisite ID |
|
| PROGRAM_ID | int | 4 | √ | null |
|
|
The ID of the program that the prerequisite belongs to |
|
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The name of the program that the prerequisite belongs to |
|
| PROGRAM_NUMBER | varchar | 255 | √ | null |
|
|
The number of the program that the prerequisite belongs to |
|
| GROUP_NUMBER | int | 4 | √ | null |
|
|
The group number that the prerequisite belongs in |
|
| PREREQUISITE_ACTIVITY_ID | int | 4 | √ | null |
|
|
The ID of the prerequisite activity |
|
| PREREQUISITE_ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
The name of the prerequisite activity |
|
| PREREQUISITE_ACTIVITY_NUMBER | varchar | 20 | √ | null |
|
|
The number of the prerequisite activity |
|
| PREREQUISITE_PROGRAM_ID | int | 4 | √ | null |
|
|
The ID of the prerequisite program |
|
| PREREQUISITE_PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The name of the prerequisite program |
|
| PREREQUISITE_PROGRAM_NUMBER | varchar | 255 | √ | null |
|
|
The number of the prerequisite program |
|
| ACTIVITY_PROGRAM_NUMBER_WILDCARD | varchar | 15 | √ | null |
|
|
The activity or program catalog number of the prerequisite activity or program |
|
| DURATION_YEARS | int | 4 | √ | null |
|
|
The maximum number of years ago that the prerequisite registration may have occurred |
|
| DURATION_MONTHS | int | 4 | √ | null |
|
|
The maximum number of months ago that the prerequisite registration may have occurred |
|
| DURATION_DAYS | int | 4 | √ | null |
|
|
The maximum number of days ago that the prerequisite registration may have occurred |
|
| PREREQUISITE_PACKAGE_ID | int | 4 | √ | null |
|
|
The ID of the prerequisite membership package |
|
| PREREQUISITE_PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The name of the prerequisite membership package |
|
| IMMEDIATE_SALE_PACKAGE | varchar | 5 | √ | null |
|
|
Whether the prerequisite membership package may be purchased at the time of registration (Yes/No) |
|
| SKILL_ID | int | 4 | √ | null |
|
|
The ID of the prerequisite skill |
|
| SKILL_NAME | varchar | 50 | √ | null |
|
|
The name of the prerequisite skill |