The Activity Section File Maintenance Clone function allows you to clone an existing Section that may have similar features to a new Section you would like to create. This process can save a tremendous amount of time, especially when building a new database.
By default the Activity File Maintenance Clone program will create exact copies of the selected Section. Additional Options allow you to specify how much information is copied in the event you do not want an exact copy. Additional Options also allow you to create a new Activity, if desired.
Click Here to view Standard File Maintenance Clone Setting field definitions for the top half of the screen. Field definitions for Additional Options specific to this module/program are listed below.
ARSectionClone_Tab1
List of NEW Activity Codes (ARSectionClone_ActivityCodeCloneList)
To create new Activities from this Section, enter an Activity Code (For Example: 200001) or a comma-delimited list with no spaces of Activity Codes ( 200001,200002,200003) in this field. The system will create as many new Activities as you list in this field, each with the number of Sections specified in the New Record Code List above.
For Example: At the top of the screen, you enter **" in the New Record Code List field "01" in the Min Sequence Number and "04" in the Max Sequence Number fields. You enter "200001 200002 200003" in the List of New Activity Codes field. When you process the clone the system will create three new Activities (200001 - 200003) each with four sections numbered 01-04.
DeleteSequence Type? (ARSectionClone_ActivityCodeSequenceType)
Expand the Drop-down list to select your Sequence Type. A selection in this field is necessary only if you opt to create cloned records using a wildcard asterisk. Making a selection here is NOT necessary if using a single New Record Code only or if using a comma-delimited list in the New Record Code List.
-
Numeric - The wildcard values will be numbers. The number of numbers will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is **-Test." Your Sequence Type is 'Numeric.' Your Min Sequence Number is "1" and your Max Sequence Number is "50." The clone process will create 50 records from 01-Test to 50-Test. -
Alpha - The wildcard values will be letters. The number of letters will be determined by the number of wildcard place holders you used in the New Record Code List field and the by the values in the Min and Max Sequence number fields.
For Example: Your New Record Code is "10150-*." Your Sequence Type is 'Alpha' Your Min Sequence Number is "0" and your Max Sequence Number is "25." The clone process will create 26 records from 10150-A to 10150-Z.
Min Sequence Number (ARSectionClone_ActivityCodeSequenceMin)
Enter the starting value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will auto-fill leading zeros as appropriate based on the number of wildcard asterisks being used in New Record Code List.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. The first code created will be Test-001. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B 2"="C and so forth.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 0." The first code created will be Test-AAA the second code will be Test-AAB etc the third code will be Test-AAC etc….
Max Sequence Number (ARSectionClone_ActivityCodeSequenceMax)
Enter the ending value of your clone sequence in this field. The field accepts numbers only.
- If your Sequence Type is 'Numeric,' the values represent themselves. The system will create as many new records as numbers in your range.
For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 1. Your Maximum Sequence Number is 999. The system will create 1,000 codes from Test-001 to Test-999. - If your Sequence Type is 'Alpha,' the values represent letters where 0" = "A 1" = "B" and so forth through "Z." In the event you have multiple asterisks the system will continue using alpha characters in the sequence of the alphabet (AAA - AAZ ABZ - AZZ BZZ-ZZZ). For Example: Your New Record Code is Test-***. Your Minimum Sequence Number is 0 . Your Maximum Sequence Number is 75. The first code created will be Test-AAA the second code will be Test-AAB etc... the 26th code will be ABZ the 27th will be ACZ etc... through to ZZZ.
The system will NOT do every possible combination of A-Z (i.e. ABA-ABZ ACA-ACZ ADA-ADZ etc…) in the event of multiple asterisks.
New Season (ARSectionClone_SeasonCloneList)
Select the appropriate Season Code for your new Sections. This is a Mandatory field for the default Vermont Systems design. Your design and setup may vary.
VSI recommends being as accurate as possible when selecting Season Codes for your activity sections as the processes of Archiving Rosters Recovering Rosters and Purging Rosters are dependent on a Season Code and Year.
Season Codes are maintained in System Code Maintenance. Type = Season.
The value in the Season field (along with the year) is stored on any enrollment activity visit miscellaneous posting instructor payment or refund records that are created.
DeleteNew Year (ARSectionClone_YearCloneList)
Enter the Year stamp for your new Sections. This is a Mandatory field for the default Vermont Systems design. Your design and setup may vary.
VSI recommends entering a Year for your activity sections as the processes of Archiving Rosters Recovering Rosters and Purging Rosters are dependent on a Season Code and Year.
The value in this field (along with the Season) is stored on any enrollment activity visit miscellaneous posting instructor payment or refund records that are created.
DeleteClone Linked Tables to this Section? (ARSectionClone_ARSectionTables)
If opting to create new Activities and Sections from the original Section, accept the default entries (all tables) or click the Picklist icon to select which information (i.e. which screen tabs) you wish to clone from the existing Activity Sections to the new Activity/Activities Sections.
Delete