| Table Name: People - 133 Fields |
| Person ID | Normal, Number | Auto-Enter:
- Serial: Generate: On creation, Next value: 3873, Increment: 1
Validation:
- Always Validate
- Strict data type: Numeric
- Not empty
- Unique
- Strict validation
- Error message: The Person ID field cannot be modified.
Storage:
- Repetitions: 1
- Indexing: All
| Auto-generated serial number |
|
|
|
|
| BYU Person ID | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Official BYU Person ID number. The internal ID uses to identify each person uniquely. Never changes. |
|
|
|
|
| Base Unit ID | Normal, Number | Validation:
- Only during data entry
- Strict validation
Storage:
- Repetitions: 1
- Indexing: All
| User selected from Units Table via script |
|
|
|
|
| __NAME DATA__ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Full Name | Normal, Text | Auto-Enter:
- Calculation: Trim ( PEOPLE_MAIN::Rest of Name ) & " " & Trim ( PEOPLE_MAIN::Last Name ) & If ( not IsEmpty (PEOPLE_MAIN::Suffix) ; " " & Trim ( PEOPLE_MAIN::Suffix ) )
Validation:
- Only during data entry
- Unique
- Error message: Another person exists with the same "Full Name." If you are sure that person is a different person, click "Yes," otherwise click "Revert Record."
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated based on name elements |
|
|
|
|
| Last Name First | Normal, Text | Auto-Enter:
- Calculation: Trim ( PEOPLE_MAIN::Last Name ) & ", " & Trim ( PEOPLE_MAIN::Rest of Name )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated based on name elements |
|
|
|
|
| Preferred Full Name | Normal, Text | Auto-Enter:
- Calculation: Trim ( PEOPLE_MAIN::Preferred Name ) & " " & Trim ( PEOPLE_MAIN::Last Name )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated based on name elements |
|
|
|
|
| Last Name | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Trim ( PEOPLE_MAIN::Last Name ) )
Validation:
- Only during data entry
- Not empty
- Strict validation
- Error message: The last name field must contain only valid letters and characters. Thanks!!
- Calculation: IsEmpty ( Filter ( PEOPLE_MAIN::Last Name ; "!@#$%^&*()_+={}[]|\:;<>?/," ) )
//Checks for any characters in the field.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered |
|
|
|
|
| Rest of Name | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Trim ( PEOPLE_MAIN::Rest of Name ) )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered |
|
|
|
|
| Preferred Name | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Case ( IsEmpty ( PEOPLE_MAIN::Preferred Name ) ;
Case (
PatternCount ( PEOPLE_MAIN::Rest of Name ; "." ) = 0 and PatternCount ( PEOPLE_MAIN::Rest of Name ; " " ) = 0 ; PEOPLE_MAIN::Rest of Name ;
PatternCount ( PEOPLE_MAIN::Rest of Name ; "." ) = 0 and PatternCount ( PEOPLE_MAIN::Rest of Name ; " " ) = 1 ; Middle ( PEOPLE_MAIN::Rest of Name ; Position ( PEOPLE_MAIN::Rest of Name ; " " ; 1 ; 1 ) + 1 ; PEOPLE_MAIN::Rest of Name ) ;
Position ( PEOPLE_MAIN::Rest of Name ; "." ; 1 ; 1 ) = 2 ; Middle ( PEOPLE_MAIN::Rest of Name ; Position ( PEOPLE_MAIN::Rest of Name ; " " ; 1 ; 1 ) + 1 ; Length ( PEOPLE_MAIN::Rest of Name ) - Position ( PEOPLE_MAIN::Rest of Name ; " " ; 1 ; 1 ) ) ;
Left ( PEOPLE_MAIN::Rest of Name; Position ( PEOPLE_MAIN::Rest of Name ; " " ; 1 ; 1 ) - 1 ) ) ;
Unformat ( PEOPLE_MAIN::Preferred Name ) )
//Assuming [Preferred Name] is Empty: Extracts the Name out of [First of Name], depending on whether there is an initial and where the initial is.
//Case 1: No initial and no space
//Case 2: No initial and 1 space
//Case 3: Initial after first letter
//Case 4: All other cases
//Middle ( text ; start ; numberOfCharacters )
//Position ( text ; searchString ; start ; occurrence )
Validation:
- Only during data entry
- Error message: The preferred name field contains characters other than letters. Is this entry correct?
- Calculation: IsEmpty ( Filter ( PEOPLE_MAIN::Preferred Name ; "!@#$%^&*()_-+={}[]|\:;<>?/," ) )
//Checks for any characters in the field.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated guess based on name elements or User Entered |
|
|
|
|
| Middle Name_Maiden Name | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Middle Name_Maiden Name )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| This is useful for find women who have married or just to have the complete middle name |
|
|
|
|
| Suffix | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Suffix )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Name Suffix |
|
|
|
|
| ---CONTACT--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Address | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Upper ( PEOPLE_MAIN::Address ) )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Campus Address |
|
|
|
|
| Phone | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Phone )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Campus Ext. or full phone number for off-campus |
|
|
|
|
| Email | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Lower ( Unformat ( PEOPLE_MAIN::Email ) )
Validation:
- Only during data entry
- Error message: The Email does not appear correct. Email addresses should have one "@" sign, at least one period, and no return characters. Allow this value?
- Calculation: PEOPLE_MAIN::Email = "" or (PatternCount ( PEOPLE_MAIN::Email ; "@") = 1 and PatternCount ( PEOPLE_MAIN::Email ; ".") > 0 and PatternCount ( PEOPLE_MAIN::Email ; "¶") = 0)
//Email addresses must have one "@" sign and at least one period and no ¶ marks.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated Guess based on Name elements or User Entered |
|
|
|
|
| Alt Phone | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Alt Phone )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| User Entered: Alternative phone number(s) |
|
|
|
|
| OffCampus Address | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::OffCampus Address )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Used for Fall Seminar invites and other times when we need a set of off-campus addresses |
|
|
|
|
| Ext Verified | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Ext Verified )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Date the validity of this person's phone number was verified (useful when sending mass phone message and the name doesn't match the extension) |
|
|
|
|
| Homepage URL | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Homepage URL )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| URL of the home page of this person |
|
|
|
|
| ----DEMOG---- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Gender | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Gender )
Validation:
- Only during data entry
- Strict validation
- Value list: Gender
- Error message: Choose "M" for Male or "F" for Female.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: "M" for Male or "F" for Female. |
|
|
|
|
| Age | Calculated, Number | Calculation:
-
Let (
[
today = Get ( CurrentDate );
original_birthdate = PEOPLE_MAIN::Birthdate;
current_birthday = Date ( Month ( original_birthdate ); Day ( original_birthdate ); Year ( today ) )
];
Year ( today ) - Year ( original_birthdate ) - Case ( today < current_birthday; 1; 0)
)
//Matt's calculation; My First Attempt: Int ( (Get ( CurrentDate ) - Birthdate)/365.25)
Storage:
- Repetitions: 1
- Indexing: All
| Calculated based on Birthdate |
|
|
|
|
| Birthdate | Normal, Date | Auto-Enter:
- Allow editing
- Calculation: Case ( PatternCount ( PEOPLE_MAIN::Birthdate ; " " ) = 2 ;
Unformat ( Case (
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Jan" ; 1 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Feb" ; 2 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Mar" ; 3 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Apr" ; 4 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "May" ; 5 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Jun" ; 6 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Jul" ; 7 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Aug" ; 8 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Sep" ; 9 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Oct" ; 10 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Nov" ; 11 ;
MiddleWords ( PEOPLE_MAIN::Birthdate ; 2 ; 1 ) = "Dec" ; 12 ) & "/" & LeftWords ( PEOPLE_MAIN::Birthdate ; 1 ) & "/" & RightWords ( PEOPLE_MAIN::Birthdate ; 1 ) ) ;
Unformat ( Date ( Month ( PEOPLE_MAIN::Birthdate ); Day ( PEOPLE_MAIN::Birthdate ); Year ( PEOPLE_MAIN::Birthdate ) ) ) )
/*Reformats the date so that no matter how the user enters the date, the date will be formatted: 9/2/2004; the first case statement covers dates pasted in from Route Y*/
Validation:
- Always Validate
- Strict data type: 4 digit year
- Strict validation
- Error message: Format dates "1/1/1960." The birthdate year must have four digits (i.e. "1960") and not be in the future. Thanks!!
- Calculation: /*Checks to make sure that the Birthdate is not more than 150 years ago or in the future*/
((Year (PEOPLE_MAIN::Birthdate) > (Year ( Get ( CurrentDate ))) - 150) and
(Year (PEOPLE_MAIN::Birthdate) ≤ (Year ( Get ( CurrentDate )))))
or
IsEmpty ( PEOPLE_MAIN::Birthdate )
Storage:
- Repetitions: 1
- Indexing: All
| User Entered |
|
|
|
|
| Nation of Origin | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Nation of Origin )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Birth Country from BYU Records or nation where the person grew up (if more releveant) |
|
|
|
|
| Ethnicity | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Ethnicity )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| From BYU Records |
|
|
|
|
| Citizenship | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Citizenship )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| From BYU Records |
|
|
|
|
| Marital Status | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Marital Status )
Validation:
- Only during data entry
- Strict validation
- Value list: Marital Status
- Error message: Choose "M" for Married or "S" for Single.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: "M" for Married or "S" for Single. |
|
|
|
|
| Religion | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Religion )
Validation:
- Only during data entry
- Value list: All Religions
- Error message: This Religion has not been used before in this database. If you are sure it is correct, do you want to add it to the value list?
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Religioius affliation of the person |
|
|
|
|
| Degree | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Degree )
Validation:
- Only during data entry
- Value list: All Degrees
- Error message: This Degree has not been used before in this database. If you are sure it is correct, do you want to add it to the value list?
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Select from Value List |
|
|
|
|
| ----JOB---- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Employee Class | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Employee Class )
Validation:
- Only during data entry
- Strict validation
- Value list: Employee Class
- Error message: Choose from the drop-down list. If the appropriate value is not listed, talk with Jane.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Select from Value List |
|
|
|
|
| Unit Role | Calculated, Text | Calculation:
-
Case (
PEOPLE_MAIN::Person ID = Lookup ( People_BUHead_P::Person ID ) ; Lookup ( Units_BU_P::Unit Type ) & " Unit Head" ;
PEOPLE_MAIN::Person ID = Lookup ( People_BUSec_P::Person ID ) ; Lookup ( Units_BU_P::Unit Type ) & " Unit Secretary" ;
PEOPLE_MAIN::Person ID = Lookup ( People_BUAcctRep_P::Person ID ) ; Lookup ( Units_BU_P::Unit Type ) & " Unit Acct Rep" ;
IsEmpty ( PEOPLE_MAIN::Base Unit ID ) ; "Not assigned to any unit" ;
Lookup ( Units_BU_P::Unit Type ) & " Unit Member" )
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Unit Type & Person's Role in relationship to their Unit |
|
|
|
|
| PT Job Description | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::PT Job Description )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| |
|
|
|
|
| RY Notes | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::RY Notes )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Data copied from RY when researching person |
|
|
|
|
| ----R&S---- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Rank | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Rank )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Select from Value List or add unique value |
|
|
|
|
| CFS Status | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::CFS Status )
Validation:
- Only during data entry
- Value list: CFS Status Categories
- Error message: Please choose a value from the drop-down list.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Select from Value List |
|
|
|
|
| First Yr CFS Track | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::First Yr CFS Track )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Track | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Track )
Validation:
- Only during data entry
- Value list: Track
- Error message: Please choose a value from the drop-down list.
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Select from Value List |
|
|
|
|
| Yr 3Yr Review | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yr 3Yr Review )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Year of this person's Third-Year Review |
|
|
|
|
| Yr 6yr Review | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yr 6yr Review )
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| Year of this person's Sixth-Year Review |
|
|
|
|
| Yr CFS Granted | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yr CFS Granted )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Year this person was granted CFS |
|
|
|
|
| Yr 1st Rank Adv | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yr 1st Rank Adv )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Year of this person's rank advancement to Associate Professor (or equivalent). |
|
|
|
|
| Yr 2nd Rank Adv | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yr 2nd Rank Adv )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Year of this person's rank advancement to Full Professor (or equivalent). |
|
|
|
|
| ---BYU DATES--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| BYU Original Hire Date | Normal, Date | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Date ( Month (PEOPLE_MAIN::BYU Original Hire Date); Day (PEOPLE_MAIN::BYU Original Hire Date); Year (PEOPLE_MAIN::BYU Original Hire Date) ) )
//Reformats the date so that no matter how the user enters the date, the date will be formatted: 9/2/2004.
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Error message: This date must be in this format: "8/23/1990"
- Calculation: /*Checks to make sure that the BYU Original Date is not more than 100 years ago or more than 2 years in the future*/
((Year (PEOPLE_MAIN::BYU Original Hire Date) > (Year ( Get ( CurrentDate ))) - 100) and
(Year (PEOPLE_MAIN::BYU Original Hire Date) < (Year ( Get ( CurrentDate )) + 2)))
or
IsEmpty ( PEOPLE_MAIN::BYU Original Hire Date )
Storage:
- Repetitions: 1
- Indexing: All
| User Entered: The earliest known hire date for this individual (post-student). Use for only historical purposes. |
|
|
|
|
| BYU Last Hire Date | Normal, Date | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Date ( Month (PEOPLE_MAIN::BYU Last Hire Date); Day (PEOPLE_MAIN::BYU Last Hire Date); Year (PEOPLE_MAIN::BYU Last Hire Date) ) )
//Reformats the date so that no matter how the user enters the date, the date will be formatted: 9/2/2004.
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Strict validation
- Error message: This date must be in this format: "8/23/1990"
- Calculation: /*Checks to make sure that the BYU Hire Date is not more than 100 years ago or more than 2 years in the future*/
((Year (PEOPLE_MAIN::BYU Last Hire Date) > (Year ( Get ( CurrentDate ))) - 100) and
(Year (PEOPLE_MAIN::BYU Last Hire Date) < (Year ( Get ( CurrentDate )) + 2)))
or
IsEmpty ( PEOPLE_MAIN::BYU Last Hire Date )
Storage:
- Repetitions: 1
- Indexing: All
| User Entered: The most recent hire date at this employee class. |
|
|
|
|
| BYU Last Hire Year | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( Year ( PEOPLE_MAIN::BYU Last Hire Date ) )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Calculated or User Entered: Year of most recent hire date. Purpose: Useful if only year, not hire date, is known. |
|
|
|
|
| First BYU Month | Normal, Text | Auto-Enter:
- Allow editing
- Do not replace existing value for field (if any)
- Calculation: Case (
Month ( PEOPLE_MAIN::BYU Last Hire Date ) > 1 and Month ( PEOPLE_MAIN::BYU Last Hire Date ) ≤ 9; "September?"; "January?")
/* If the person is hired between February to September, then GUESS that the first month working is September; If the person is hired on between September to January, then GUESS that the first month working is January. This assumptions could be false and can be changed by the user */
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Calculated or User Entered: First month of working at BYU at this employee class. |
|
|
|
|
| Left BYU Year | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Left BYU Year )
Validation:
- Only during data entry
- Strict validation
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| User Entered: Year this person left BYU |
|
|
|
|
| Left BYU Reason | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Left BYU Reason )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| User Entered: Reason why this person left BYU (Retired, New Job, Contract ended, etc.) |
|
|
|
|
| BYU History Notes | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::BYU History Notes )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Any notes about this person's history at BYU, including Employee Class this person had before the present position. |
|
|
|
|
| Activity Status | Normal, Text | Auto-Enter:
- Constant data: Active
- Allow editing
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Active = Still Active in current unit; InActive = Gone from current unit; OnLeave = Temporarily gone from current unit; |
|
|
|
|
| ---HISTORY--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Yrs Exp NonBYU | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yrs Exp NonBYU )
Validation:
- Only during data entry
- Range: 0 - 50
- Error message: Double-check the number entered to make sure it is correct. Allow this value?
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| User Entered: Number of years worked at this employee class NOT AT BYU. |
|
|
|
|
| Yrs Exp BYU B4 Hire | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yrs Exp BYU B4 Hire )
Validation:
- Only during data entry
- Range: 0 - 30
- Error message: Double-check the number entered to make sure it is correct. Allow this value?
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| User Entered: Number of years worked at this employee class at BYU PREVIOUS to the last hire date. |
|
|
|
|
| Yrs Exp Place Unknown | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Yrs Exp Place Unknown )
Validation:
- Only during data entry
- Range: 0 - 50
- Error message: Double-check the number entered to make sure it is correct. Allow this value?
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| User Entered: Number of years worked at this employee class PLACE UNKNOWN. |
|
|
|
|
| Yrs Since BYU Hire | Calculated, Number | Calculation:
- /*Only return a result of there is a valid year in BYU HIRE YEAR */
Case((PEOPLE_MAIN::BYU Last Hire Year < 1900 and PEOPLE_MAIN::BYU Last Hire Year > 10000) or IsEmpty ( PEOPLE_MAIN::BYU Last Hire Year ); "";
/*If LEFT BYU = "No" or "Temp" or there is not a valid year in LEFT BYU, Calculate CURRENT YEAR - BYU Hire Year*/
PEOPLE_MAIN::Left BYU Year = "No" or PEOPLE_MAIN::Left BYU Year = "Temp" or PEOPLE_MAIN::Left BYU Year - PEOPLE_MAIN::BYU Last Hire Year<0; Year ( Get ( CurrentDate ) ) - PEOPLE_MAIN::BYU Last Hire Year;
/*OR: IF there is a valid number in LEFT BYU: Calculate YR LEFT BYU - BYU Hire Year*/
PEOPLE_MAIN::Left BYU Year > 1900 or PEOPLE_MAIN::Left BYU Year < 10000; PEOPLE_MAIN::Left BYU Year - PEOPLE_MAIN::BYU Last Hire Year;
/*DEFAULT VALUE: ""*/
"")
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Today's year (or Year Left BYU) minus last BYU Hire Year. |
|
|
|
|
| Yrs Exp BYU Total | Calculated, Number | Calculation:
-
PEOPLE_MAIN::Yrs Exp BYU B4 Hire + PEOPLE_MAIN::Yrs Since BYU Hire
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Total number of years at this employee class at BYU. |
|
|
|
|
| Yrs Exp Total | Calculated, Number | Calculation:
-
PEOPLE_MAIN::Yrs Exp NonBYU + PEOPLE_MAIN::Yrs Exp BYU Total + PEOPLE_MAIN::Yrs Exp Place Unknown
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Total number of years at this employee class TOTAL. |
|
|
|
|
| Year_Reported__First_Full_time_Faculty_Position | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Year of Report_Whether or not this is the person's first full-time faculty position that year |
|
|
|
|
| --MISC FIELDS-- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| NetID | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::NetID )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Official BYU netID number. |
|
|
|
|
| BYU ID | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::BYU ID )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| New BYU ID number. |
|
|
|
|
| Corrected LNF | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Used to compare against older MS Works data |
|
|
|
|
| Head Unit ID | Normal, Number | Auto-Enter:
- Calculation: Units_HUData_P::Unit ID
Validation:
- Only during data entry
- Strict validation
Storage:
- Repetitions: 1
- Indexing: All
| This is here so I can make a compound match for members of HU in People. |
|
|
|
|
| Home Unit ID | Normal, Number | Auto-Enter:
- Allow editing
- Calculation: Units_HomeUnitName_P::Unit ID
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Auto entered via scripts Based on Home Unit Name |
|
|
|
|
| Home Unit Name | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Units_HomeUnitID_P::Unit Name
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Auto entered via scripts OR User selected |
|
|
|
|
| Home Discipline | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Home Discipline )
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: English
| Taken from Presenter db. Use to update the Home Unit |
|
|
|
|
| Audit Log | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Right ( PEOPLE_MAIN::Person ID & PEOPLE_MAIN::BYU Person ID & PEOPLE_MAIN::Base Unit ID & PEOPLE_MAIN::Preferred Name & PEOPLE_MAIN::Last Name & PEOPLE_MAIN::Rest of Name & PEOPLE_MAIN::Middle Name_Maiden Name & PEOPLE_MAIN::Suffix & PEOPLE_MAIN::Address & PEOPLE_MAIN::Email & PEOPLE_MAIN::Phone & PEOPLE_MAIN::Alt Phone & PEOPLE_MAIN::OffCampus Address & PEOPLE_MAIN::Gender & PEOPLE_MAIN::Birthdate & PEOPLE_MAIN::Nation of Origin & PEOPLE_MAIN::Ethnicity & PEOPLE_MAIN::Citizenship & PEOPLE_MAIN::Marital Status & PEOPLE_MAIN::Religion & PEOPLE_MAIN::Degree & PEOPLE_MAIN::PT Job Description & PEOPLE_MAIN::Employee Class & PEOPLE_MAIN::RY Notes & PEOPLE_MAIN::Rank & PEOPLE_MAIN::CFS Status & PEOPLE_MAIN::First Yr CFS Track & PEOPLE_MAIN::Track & PEOPLE_MAIN::Yr 3Yr Review & PEOPLE_MAIN::Yr 6yr Review & PEOPLE_MAIN::Yr CFS Granted & PEOPLE_MAIN::Yr 1st Rank Adv & PEOPLE_MAIN::Yr 2nd Rank Adv & PEOPLE_MAIN::BYU Original Hire Date & PEOPLE_MAIN::BYU Last Hire Date & PEOPLE_MAIN::BYU Last Hire Year & PEOPLE_MAIN::First BYU Month & PEOPLE_MAIN::Left BYU Year & PEOPLE_MAIN::Left BYU Reason & PEOPLE_MAIN::BYU History Notes & PEOPLE_MAIN::Activity Status & PEOPLE_MAIN::Yrs Exp NonBYU & PEOPLE_MAIN::Yrs Exp BYU B4 Hire & PEOPLE_MAIN::Yrs Exp Place Unknown & PEOPLE_MAIN::NetID & PEOPLE_MAIN::BYU ID & PEOPLE_MAIN::Head Unit ID & PEOPLE_MAIN::Home Unit Name & PEOPLE_MAIN::Home Discipline & PEOPLE_MAIN::Jane Notes; 0 )
&
"Date: " & DataGlobals::gTab & " Time: " & DataGlobals::gTab & "AccountName: " & DataGlobals::gTab & "Field: " & DataGlobals::gTab & "From: " & DataGlobals::gTab & "-->" & DataGlobals::gTab & "To:¶--------------------------------------------------------------------------------------------------------------------------------------------------------------¶" &
Case ( Length ( Get ( ActiveFieldName ) ) ;
Get ( CurrentDate ) & DataGlobals::gTab &
Get ( CurrentTime ) & DataGlobals::gTab &
Left ( Get ( AccountName ) & " " ; 20 ) & DataGlobals::gTab &
Left ( Get ( ActiveFieldName ) & " " ; 20 ) & DataGlobals::gTab &
Substitute ( MiddleValues ( PEOPLE_MAIN::Audit Previous; ValueCount ( Left ( "¶" & PEOPLE_MAIN::Audit Previous; Position ( PEOPLE_MAIN::Audit Previous; "¶" & Get ( ActiveFieldName ) & "››"; 1; 1 ) ) ) ; 1 ) ; ["¶"; ""]; [Get ( ActiveFieldName ) & "››"; ""] ) &
DataGlobals::gTab & "-->" & DataGlobals::gTab &
If ( Length ( GetField ( Get ( ActiveFieldName ) ) ) ; Substitute ( GetField ( Get ( ActiveFieldName ) ) ; "¶"; "‡" ) ; "[Null]" ) ) & Case ( not IsEmpty ( GetField ( "Audit Log" ) ) ; Case ( Length ( Get ( ActiveFieldName ) ) ; "¶" ) & Middle ( GetField ( "Audit Log" ) ; Position ( GetField ( "Audit Log" ) ; "¶"; 1; 2 ) + 1; Length ( GetField ( "Audit Log" ) ) ) )
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| This field auto-enters the log text, accumulating as edits are made. New fields can be added to the calculations. |
|
|
|
|
| Audit Previous | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Case ( IsEmpty ( PEOPLE_MAIN::Audit Log ) or not IsEmpty ( PEOPLE_MAIN::Audit Log ) ;
"Person ID" & "››" & If ( IsEmpty ( GetField ( "Person ID" ) ) ; "[Null]"; Substitute ( GetField ( "Person ID" ) ; "¶"; "‡" ) ) & "¶" &
"BYU Person ID" & "››" & If ( IsEmpty ( GetField ( "BYU Person ID" ) ) ; "[Null]"; Substitute ( GetField ( "BYU Person ID" ) ; "¶"; "‡" ) ) & "¶" &
"Base Unit ID" & "››" & If ( IsEmpty ( GetField ( "Base Unit ID" ) ) ; "[Null]"; Substitute ( GetField ( "Base Unit ID" ) ; "¶"; "‡" ) ) & "¶" &
"Preferred Name" & "››" & If ( IsEmpty ( GetField ( "Preferred Name" ) ) ; "[Null]"; Substitute ( GetField ( "Preferred Name" ) ; "¶"; "‡" ) ) & "¶" &
"Last Name"& "››" & If ( IsEmpty ( GetField ( "Last Name") ) ; "[Null]"; Substitute ( GetField ( "Last Name") ; "¶"; "‡" ) ) & "¶" &
"Rest of Name"& "››" & If ( IsEmpty ( GetField ( "Rest of Name") ) ; "[Null]"; Substitute ( GetField ( "Rest of Name") ; "¶"; "‡" ) ) & "¶" &
"Middle Name_Maiden Name"& "››" & If ( IsEmpty ( GetField ( "Middle Name_Maiden Name") ) ; "[Null]"; Substitute ( GetField ( "Middle Name_Maiden Name") ; "¶"; "‡" ) ) & "¶" &
"Suffix" & "››" & If ( IsEmpty ( GetField ( "Suffix" ) ) ; "[Null]"; Substitute ( GetField ( "Suffix" ) ; "¶"; "‡" ) ) & "¶" &
"Address" & "››" & If ( IsEmpty ( GetField ( "Address" ) ) ; "[Null]"; Substitute ( GetField ( "Address" ) ; "¶"; "‡" ) ) & "¶" &
"Email" & "››" & If ( IsEmpty ( GetField ( "Email" ) ) ; "[Null]"; Substitute ( GetField ( "Email" ) ; "¶"; "‡" ) ) & "¶" &
"Phone" & "››" & If ( IsEmpty ( GetField ( "Phone" ) ) ; "[Null]"; Substitute ( GetField ( "Phone" ) ; "¶"; "‡" ) ) & "¶" &
"Alt Phone" & "››" & If ( IsEmpty ( GetField ( "Alt Phone" ) ) ; "[Null]"; Substitute ( GetField ( "Alt Phone" ) ; "¶"; "‡" ) ) & "¶" &
"OffCampus Address" & "››" & If ( IsEmpty ( GetField ( "OffCampus Address" ) ) ; "[Null]"; Substitute ( GetField ( "OffCampus Address" ) ; "¶"; "‡" ) ) & "¶" &
"Gender" & "››" & If ( IsEmpty ( GetField ( "Gender" ) ) ; "[Null]"; Substitute ( GetField ( "Gender" ) ; "¶"; "‡" ) ) & "¶" &
"Age" & "››" & If ( IsEmpty ( GetField ( "Age" ) ) ; "[Null]"; Substitute ( GetField ( "Age" ) ; "¶"; "‡" ) ) & "¶" &
"Birthdate" & "››" & If ( IsEmpty ( GetField ( "Birthdate" ) ) ; "[Null]"; Substitute ( GetField ( "Birthdate" ) ; "¶"; "‡" ) ) & "¶" &
"Nation of Origin" & "››" & If ( IsEmpty ( GetField ( "Nation of Origin" ) ) ; "[Null]"; Substitute ( GetField ( "Nation of Origin" ) ; "¶"; "‡" ) ) & "¶" &
"Ethnicity" & "››" & If ( IsEmpty ( GetField ( "Ethnicity" ) ) ; "[Null]"; Substitute ( GetField ( "Ethnicity" ) ; "¶"; "‡" ) ) & "¶" &
"Citizenship" & "››" & If ( IsEmpty ( GetField ( "Citizenship" ) ) ; "[Null]"; Substitute ( GetField ( "Citizenship" ) ; "¶"; "‡" ) ) & "¶" &
"Marital Status" & "››" & If ( IsEmpty ( GetField ( "Marital Status" ) ) ; "[Null]"; Substitute ( GetField ( "Marital Status" ) ; "¶"; "‡" ) ) & "¶" &
"Religion" & "››" & If ( IsEmpty ( GetField ( "Religion" ) ) ; "[Null]"; Substitute ( GetField ( "Religion" ) ; "¶"; "‡" ) ) & "¶" &
"Degree" & "››" & If ( IsEmpty ( GetField ( "Degree" ) ) ; "[Null]"; Substitute ( GetField ( "Degree" ) ; "¶"; "‡" ) ) & "¶" &
"PT Job Description" & "››" & If ( IsEmpty ( GetField ( "PT Job Description" ) ) ; "[Null]"; Substitute ( GetField ( "PT Job Description" ) ; "¶"; "‡" ) ) & "¶" &
"Employee Class" & "››" & If ( IsEmpty ( GetField ( "Employee Class" ) ) ; "[Null]"; Substitute ( GetField ( "Employee Class" ) ; "¶"; "‡" ) ) & "¶" &
"RY Notes" & "››" & If ( IsEmpty ( GetField ( "RY Notes" ) ) ; "[Null]"; Substitute ( GetField ( "RY Notes" ) ; "¶"; "‡" ) ) & "¶" &
"Rank" & "››" & If ( IsEmpty ( GetField ( "Rank" ) ) ; "[Null]"; Substitute ( GetField ( "Rank" ) ; "¶"; "‡" ) ) & "¶" &
"CFS Status" & "››" & If ( IsEmpty ( GetField ( "CFS Status" ) ) ; "[Null]"; Substitute ( GetField ( "CFS Status" ) ; "¶"; "‡" ) ) & "¶" &
"First Yr CFS Track" & "››" & If ( IsEmpty ( GetField ( "First Yr CFS Track" ) ) ; "[Null]"; Substitute ( GetField ( "First Yr CFS Track" ) ; "¶"; "‡" ) ) & "¶" &
"Track" & "››" & If ( IsEmpty ( GetField ( "Track" ) ) ; "[Null]"; Substitute ( GetField ( "Track" ) ; "¶"; "‡" ) ) & "¶" &
"Yr 3Yr Review" & "››" & If ( IsEmpty ( GetField ( "Yr 3Yr Review" ) ) ; "[Null]"; Substitute ( GetField ( "Yr 3Yr Review" ) ; "¶"; "‡" ) ) & "¶" &
"Yr 6yr Review" & "››" & If ( IsEmpty ( GetField ( "Yr 6yr Review" ) ) ; "[Null]"; Substitute ( GetField ( "Yr 6yr Review" ) ; "¶"; "‡" ) ) & "¶" &
"Yr CFS Granted" & "››" & If ( IsEmpty ( GetField ( "Yr CFS Granted" ) ) ; "[Null]"; Substitute ( GetField ( "Yr CFS Granted" ) ; "¶"; "‡" ) ) & "¶" &
"Yr 1st Rank Adv" & "››" & If ( IsEmpty ( GetField ( "Yr 1st Rank Adv" ) ) ; "[Null]"; Substitute ( GetField ( "Yr 1st Rank Adv" ) ; "¶"; "‡" ) ) & "¶" &
"Yr 2nd Rank Adv" & "››" & If ( IsEmpty ( GetField ( "Yr 2nd Rank Adv" ) ) ; "[Null]"; Substitute ( GetField ( "Yr 2nd Rank Adv" ) ; "¶"; "‡" ) ) & "¶" &
"BYU Original Hire Date" & "››" & If ( IsEmpty ( GetField ( "BYU Original Hire Date" ) ) ; "[Null]"; Substitute ( GetField ( "BYU Original Hire Date" ) ; "¶"; "‡" ) ) & "¶" &
"BYU Last Hire Date" & "››" & If ( IsEmpty ( GetField ( "BYU Last Hire Date" ) ) ; "[Null]"; Substitute ( GetField ( "BYU Last Hire Date" ) ; "¶"; "‡" ) ) & "¶" &
"BYU Last Hire Year" & "››" & If ( IsEmpty ( GetField ( "BYU Last Hire Year" ) ) ; "[Null]"; Substitute ( GetField ( "BYU Last Hire Year" ) ; "¶"; "‡" ) ) & "¶" &
"Left BYU Year" & "››" & If ( IsEmpty ( GetField ( "Left BYU Year" ) ) ; "[Null]"; Substitute ( GetField ( "Left BYU Year" ) ; "¶"; "‡" ) ) & "¶" &
"Left BYU Reason" & "››" & If ( IsEmpty ( GetField ( "Left BYU Reason" ) ) ; "[Null]"; Substitute ( GetField ( "Left BYU Reason" ) ; "¶"; "‡" ) ) & "¶" &
"BYU History Notes" & "››" & If ( IsEmpty ( GetField ( "BYU History Notes" ) ) ; "[Null]"; Substitute ( GetField ( "BYU History Notes" ) ; "¶"; "‡" ) ) & "¶" &
"Activity Status" & "››" & If ( IsEmpty ( GetField ( "Activity Status" ) ) ; "[Null]"; Substitute ( GetField ( "Activity Status" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Exp NonBYU" & "››" & If ( IsEmpty ( GetField ( "Yrs Exp NonBYU" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Exp NonBYU" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Exp BYU B4 Hire" & "››" & If ( IsEmpty ( GetField ( "Yrs Exp BYU B4 Hire" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Exp BYU B4 Hire" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Exp Place Unknown" & "››" & If ( IsEmpty ( GetField ( "Yrs Exp Place Unknown" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Exp Place Unknown" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Since BYU Hire" & "››" & If ( IsEmpty ( GetField ( "Yrs Since BYU Hire" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Since BYU Hire" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Exp BYU Total" & "››" & If ( IsEmpty ( GetField ( "Yrs Exp BYU Total" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Exp BYU Total" ) ; "¶"; "‡" ) ) & "¶" &
"Yrs Exp Total" & "››" & If ( IsEmpty ( GetField ( "Yrs Exp Total" ) ) ; "[Null]"; Substitute ( GetField ( "Yrs Exp Total" ) ; "¶"; "‡" ) ) & "¶" &
"NetID" & "››" & If ( IsEmpty ( GetField ( "NetID" ) ) ; "[Null]"; Substitute ( GetField ( "NetID" ) ; "¶"; "‡" ) ) & "¶" &
"BYU ID" & "››" & If ( IsEmpty ( GetField ( "BYU ID" ) ) ; "[Null]"; Substitute ( GetField ( "BYU ID" ) ; "¶"; "‡" ) ) & "¶" &
"Head Unit ID" & "››" & If ( IsEmpty ( GetField ( "Head Unit ID" ) ) ; "[Null]"; Substitute ( GetField ( "Head Unit ID" ) ; "¶"; "‡" ) ) & "¶" &
"Home Unit Name" & "››" & If ( IsEmpty ( GetField ( "Home Unit Name" ) ) ; "[Null]"; Substitute ( GetField ( "Home Unit Name" ) ; "¶"; "‡" ) ) & "¶" &
"Home Discipline" & "››" & If ( IsEmpty ( GetField ( "Home Discipline" ) ) ; "[Null]"; Substitute ( GetField ( "Home Discipline" ) ; "¶"; "‡" ) ) & "¶" &
"Jane Notes" & "››" & If ( IsEmpty ( GetField ( "Jane Notes" ) ) ; "[Null]"; Substitute ( GetField ( "Jane Notes" ) ; "¶"; "‡" ) )
)
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| This field holds the history of immediately previous values to be passed into the log calculation. New/changed fields require editing this field. |
|
|
|
|
| ___SUM FIELDS___ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| Summary Fields |
|
|
|
|
| Number of People | Summary, Number | Summary Information:
| |
|
|
|
|
| __ADMIN GLOBALS__ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| psSelect_EmployeeClass | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: PEOPLE_MAIN::psSelect_EmployeeClass & External ( "Menu-PerformScript"; "ps-Refresh Layout" )
Validation:
Storage:
| User selects which employee classes to view in the Unit portals (for both People and Units). Performs SFM script-Refresh Layout. Default: "FT Faculty" |
|
|
|
|
| psSelect_ActivityStatus | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: PEOPLE_MAIN::psSelect_ActivityStatus & External ( "Menu-PerformScript"; "ps-Refresh Layout")
Validation:
Storage:
| User selects which Activity Status to view in the Unit portals (for both People and Units). Performs SFM script-Refresh Layout. Default: "Active" |
|
|
|
|
| gSelect_UnitType | Normal, Text | Validation:
Storage:
| User Entered: Select Unit Type from Value List to view/select desired units [Match Field]. Default: "Department" |
|
|
|
|
| gSelectProgMenuCategory | Normal, Text | Validation:
Storage:
| User can select the Menu Category to see Admin prog/events in that category. Click button to insert "All Categories" to see all of them. Default: "On-going Programs" |
|
|
|
|
| gPeople ID MultiKey | Normal, Text | Validation:
Storage:
| Global to store multiple global IDs to match with Person ID when trying to isolate a found set of people. Default: "" |
|
|
|
|
| gCurrent Account Name | Normal, Text | Validation:
Storage:
| Account Name of Current User (used in People related fields to set Record Owner). Default: "" |
|
|
|
|
| gIncludeExcludeInvitees | Normal, Text | Validation:
Storage:
| Value changes based on value in [UserSelectFields::gIncludeorExclude Invitees] |
|
|
|
|
| gLastError | Normal, Number | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| Global to put the Last Error code into in order to display the relevant Error Description |
|
|
|
|
| __ADMIN CALCS__ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| cLastName Alpha | Calculated, Text | Calculation:
-
Left ( PEOPLE_MAIN::Last Name; 1 )
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Calculated: First letter of the Last Name; Used to filter people by last name in portal for Unit Admin |
|
|
|
|
| cLastName Alpha Three | Calculated, Text | Calculation:
-
Left ( PEOPLE_MAIN::Last Name; 3 )
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Calculated: First three letters of the Last Name; Used to filter people by last name in portal for Photo selection |
|
|
|
|
| cView gSelectGetField | Calculated, Text | Calculation:
-
Case (
UserSelectFields::gSelectGetField = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gSelectGetField = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gSelectGetField = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gSelectGetField = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gSelectGetField = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gSelectGetField = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gSelectGetField = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gSelectGetField = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gSelectGetField = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gSelectGetField = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gSelectGetField = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gSelectGetField = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gSelectGetField = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gSelectGetField = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gSelectGetField = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gSelectGetField = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gSelectGetField = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gSelectGetField)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Displays the value of whatever field is chosen in [UserSelectFields::gSelectGetField]. Allows users to chose their own fields to view. |
|
|
|
|
| cLength of Text | Calculated, Number | Calculation:
-
Length (PEOPLE_MAIN::Last Name First)
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
| Can be changed to find the length of text in any field (used to find the longest length). |
|
|
|
|
| cPhoto File Name to Match | Calculated, Text | Calculation:
-
Trim ( PEOPLE_MAIN::Last Name ) & "_" & Substitute ( Trim ( PEOPLE_MAIN::Rest of Name ) ; " " ; "_" ) & "_2005.jpg"
//Substitute ( Trim ( Last Name ) & "_" & Substitute ( Trim ( Rest of Name ) ; " " ; "_" ) ; "." ; "" ) & "_2005.jpg"
Storage:
- Repetitions: 1
- Do not store calculation results
| Insert estimate of what the photo file name for this person will be to try to import Person IDs into Photos. |
|
|
|
|
| cText is Invitee | Calculated, Text | Calculation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| "Invitee" for Participant/Presenter Counts |
|
|
|
|
| cYes for Current Photo | Calculated, Text | Calculation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| "Yes" for Current Photo |
|
|
|
|
| gConstant1 | Calculated, Number | Calculation:
Storage:
| Used in relationship to find all photos with Person ID's (Person ID > than this field) |
|
|
|
|
| cCurrent Spring Seminar | Calculated, Number | Calculation:
Storage:
- Repetitions: 1
- Indexing: All
| The Event ID of the current Spring Seminar to match in FDSPlus file for lists for chairs |
|
|
|
|
| cCurrent Fall Seminar | Calculated, Number | Calculation:
Storage:
- Repetitions: 1
- Indexing: All
| The Event ID of the current Fall Seminar to match in FDSPlus file for lists for chairs |
|
|
|
|
| --PROG ADMIN-- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| gFind Program Title | Normal, Text | Validation:
Storage:
| Field to hold Program Title to be searched to Find Participants of that Program. Also used for Value List. Default: "" |
|
|
|
|
| gFind Event Title | Normal, Text | Validation:
Storage:
| Field to hold Event Title to be searched to Find Participants of that Event. Also used for Value List. Default: "" |
|
|
|
|
| gFind Person Role | Normal, Text | Validation:
Storage:
| Field to hold Person Role to be searched to Find Participants. Default: "" |
|
|
|
|
| gAdd Program Title | Normal, Text | Validation:
- Only during data entry
- Strict validation
Storage:
| Global inserted through scripts or chosen by user to select Program to add participants to. Also used for Value List. Default: "" |
|
|
|
|
| gAdd Event Title | Normal, Text | Validation:
- Only during data entry
- Strict validation
Storage:
| Global inserted through scripts or chosen by user to select Event to add participants to. Vital for exporting to Participants. Default: "" |
|
|
|
|
| gIDEvtToAdd | Normal, Number | Validation:
Storage:
| When I tried to make this a global calculation, it didn't work (for unknown reasons), so I'm going to set it when it is needed. |
|
|
|
|
| ---MOD DATA--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Creator | Normal, Text | Auto-Enter:
- Creation account name
- Allow editing
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Auto-generated |
|
|
|
|
| Creation TimeStamp | Normal, Timestamp | Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Auto-generated |
|
|
|
|
| Modifier | Normal, Text | Auto-Enter:
- Modification account name
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Auto-generated |
|
|
|
|
| Modify TimeStamp | Normal, Timestamp | Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: All
| Auto-generated |
|
|
|
|
| ---Stats--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| cBase Unit Count | Calculated, Number | Calculation:
-
Count (zscPeople_BU_EmpCl_ActivityStatus::Person ID)
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Total count of people in unit based on the Employee Class(es) chosen by the user. |
|
|
|
|
| cHead Unit Count | Calculated, Number | Calculation:
-
Count (zscPeople_HU_EmpCl_ActivityStatus::Person ID)
Storage:
- Repetitions: 1
- Do not store calculation results
| Calculated: Total count of people in unit based on the Employee Class(es) chosen by the user. |
|
|
|
|
| cInvitee Count | Calculated, Number | Calculation:
-
Case ( not IsValid ( zParticipants_P_CountAll::Participant ID ); 0; Count ( zParticipants_P_CountAll::Participant ID ))
/*If this person is not a participant in any event, 0, otherwise, the count*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of times this person has been a participant in an Event (either invitee or attendee) |
|
|
|
|
| cAttendee Count | Calculated, Number | Calculation:
-
Case ( not IsValid ( zParticipants_P_CountNOInvitees::Participant ID ); 0; Count ( zParticipants_P_CountNOInvitees::Participant ID ))
/*If there are No Attendees (non-Invitees), 0, otherwise, the count*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of times this person has been marked as an non-Invitee in an Event |
|
|
|
|
| cPresenter Invitee Count | Calculated, Number | Calculation:
-
Case ( not IsValid ( zPresenters_P_CountAll::Presenter ID ); 0; Count ( zPresenters_P_CountAll::Presenter ID ))
/*If this person is not a participant in any event, 0, otherwise, the count*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of times this person has been a presenter in an Event (either invitee or attendee) |
|
|
|
|
| cPresenter Attendee Count | Calculated, Number | Calculation:
-
Case ( not IsValid ( zPresenters_P_CountNOInvitees::Presenter ID ); 0; Count ( zPresenters_P_CountNOInvitees::Presenter ID ))
/*If there are No Attendees (non-Invitees), 0, otherwise, the count*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of times this person has been marked as an non-Invitee in an Event |
|
|
|
|
| cAdministrator Count | Calculated, Number | Calculation:
-
Case ( not IsValid ( zEvtAdmin_P_CountAll::Person ID ); 0; Count ( zEvtAdmin_P_CountAll::Person ID ))
/*If the person is not listed as an administrator for any event, 0, otherwise, the count*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of times this person has been marked as Administrator in an Event |
|
|
|
|
| cPhoto Count | Calculated, Number | Calculation:
-
Case ( IsEmpty ( Photos_People::Photo ID ) ; "0" ; Count ( Photos_People::Photo ID ) )
Storage:
- Repetitions: 1
- Do not store calculation results
| Number of Photos from this Person |
|
|
|
|
| ---EXPORT--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Export Field 1 | Calculated, Text | Calculation:
-
Case (
UserSelectFields::gPeople Export 1 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 1 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 1 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 1 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 1 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 1 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 1 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 1 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 1 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 1 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 1 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 1 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 1 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 1 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 1 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 1 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 1 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 1)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 2 | Calculated, Text | Calculation:
-
Case (
UserSelectFields::gPeople Export 2 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 2 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 2 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 2 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 2 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 2 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 2 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 2 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 2 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 2 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 2 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 2 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 2 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 2 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 2 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 2 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 2 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 2)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 3 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 3 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 3 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 3 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 3 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 3 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 3 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 3 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 3 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 3 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 3 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 3 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 3 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 3 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 3 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 3 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 3 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 3 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 3)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 4 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 4 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 4 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 4 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 4 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 4 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 4 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 4 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 4 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 4 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 4 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 4 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 4 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 4 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 4 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 4 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 4 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 4 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 4)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 5 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 5 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 5 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 5 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 5 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 5 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 5 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 5 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 5 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 5 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 5 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 5 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 5 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 5 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 5 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 5 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 5 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 5 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 5)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 6 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 6 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 6 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 6 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 6 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 6 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 6 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 6 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 6 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 6 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 6 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 6 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 6 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 6 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 6 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 6 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 6 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 6 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 6)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 7 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 7 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 7 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 7 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 7 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 7 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 7 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 7 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 7 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 7 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 7 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 7 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 7 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 7 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 7 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 7 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 7 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 7 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 7)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 8 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 8 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 8 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 8 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 8 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 8 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 8 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 8 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 8 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 8 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 8 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 8 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 8 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 8 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 8 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 8 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 8 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 8 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 8)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 9 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 9 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 9 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 9 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 9 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 9 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 9 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 9 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 9 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 9 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 9 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 9 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 9 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 9 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 9 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 9 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 9 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 9 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 9)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| Export Field 10 | Calculated, Text | Calculation:
-
Case (UserSelectFields::gPeople Export 10 = "Current Title"; Jobs_People::Current Title;
UserSelectFields::gPeople Export 10 = "Unit Type"; Units_BU_P::Unit Type;
UserSelectFields::gPeople Export 10 = "Base Unit"; Units_BU_P::Unit Name;
UserSelectFields::gPeople Export 10 = "Base Unit Abbrev"; Units_BU_P::Unit Abbrev;
UserSelectFields::gPeople Export 10 = "Base Unit Short"; Units_BU_P::Unit Short;
UserSelectFields::gPeople Export 10 = "BU Head"; People_BUHead_P::Full Name;
UserSelectFields::gPeople Export 10 = "BU Head Phone"; People_BUHead_P::Phone;
UserSelectFields::gPeople Export 10 = "BU Head Address"; People_BUHead_P::Address;
UserSelectFields::gPeople Export 10 = "BU Head Email"; People_BUHead_P::Email;
UserSelectFields::gPeople Export 10 = "Head Unit Type"; Units_HUData_P::Unit Type;
UserSelectFields::gPeople Export 10 = "Head Unit"; Units_HUData_P::Unit Name;
UserSelectFields::gPeople Export 10 = "Head Unit Abbrev"; Units_HUData_P::Unit Abbrev;
UserSelectFields::gPeople Export 10 = "Head Unit Short"; Units_HUData_P::Unit Short;
UserSelectFields::gPeople Export 10 = "HU Head"; People_HUHead_P::Full Name;
UserSelectFields::gPeople Export 10 = "HU Head Phone"; People_HUHead_P::Phone;
UserSelectFields::gPeople Export 10 = "HU Head Address"; People_HUHead_P::Address;
UserSelectFields::gPeople Export 10 = "HU Head Email"; People_HUHead_P::Email;
GetField (UserSelectFields::gPeople Export 10)) /*The default value is the name of the field as it appears in the global (this only works if the field is in the People table*/
Storage:
- Repetitions: 1
- Do not store calculation results
| Contains value of field selected by the user to export |
|
|
|
|
| __KEEPBOTTOM__ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| Access restricted field causes problems when importing fields created after this field (created 1.27.05) |
|
|
|
|
| Jane Notes | Normal, Text | Auto-Enter:
- Allow editing
- Calculation: Unformat ( PEOPLE_MAIN::Jane Notes )
Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Any notes about this person that only Jane can see. |
|
|
|
|
| ___IMPORT FIELDS___ | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| Utility fields to use for importing |
|
|
|
|
| Data Imported | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: English
| Temporarily hold any data that has been imported that I want to check against other data |
|
|
|
|
| Compare Data Imported | Calculated, Number | Calculation:
-
Case ( Length ( LeftWords ( PEOPLE_MAIN::Rest of Name ; 1 ) > 1 ) ; PatternCount ( PEOPLE_MAIN::Middle Name_Maiden Name ; LeftWords ( PEOPLE_MAIN::Rest of Name ; 1 ) ))
Storage:
- Repetitions: 1
- Indexing: All
| Calc used to compare any two fields to see if they match up |
|
|
|
|
| ---TEMP--- | Normal, Text | Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: English
| |
|
|
|
|
| Temp | Calculated, Number | Calculation:
-
Length (PEOPLE_MAIN::Full Name)
Storage:
- Repetitions: 1
- Indexing: All
| |
|
|
|
|