Data type: Pseudo field

The pseudo field data type is a legacy compound data type represented by the number 12 in the database dictionary. A pseudo field is similar to a function, because it converts input data to output data and can sometimes be assigned. It can be placed on the left-hand side of the equals (=) sign in an assignment statement. Service Manager has pre-defined pseudo-fields (Month and Name). Pseudo fields were supported for legacy ServiceCenter data but are not supported by SQL tables. The following tables describe the pseudo fields.

Month  
Explanation Accesses the number of months from the beginning of the time base in a date. Use it to increment a date by a period of months.
Format

Month in $time +=1

This increments the current month by one.

Factors The month pseudo field is useful for scheduling monthly reports, since it calculates the number of days to add to each month.
Name  
Explanation Accesses the file name in a specific file variable.
Format $filename=Name in $file
This sets $filename to the name of the file bound to $file.
Factors The name pseudo field is analogous to the filename function