This page (revision-20) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by KHanson

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
20 26-Nov-2021 10:22 6 KB jmyers to previous
19 26-Nov-2021 10:22 7 KB jmyers to previous | to last EMAIL_ADDRESS ==> EMAIL_ADDRESS(Disambiguation)
18 26-Nov-2021 10:22 7 KB JEscott to previous | to last INCLUDE_ALL_IN_UENH ==> INCLUDE_ALL_IN_UEHN
17 26-Nov-2021 10:22 7 KB JMyers to previous | to last
16 26-Nov-2021 10:22 7 KB RForbes to previous | to last
15 26-Nov-2021 10:22 7 KB RForbes to previous | to last X_BILINGUAL_REGIONS ==> X_BILINGUAL_REGION
14 26-Nov-2021 10:22 7 KB RForbes to previous | to last
13 26-Nov-2021 10:22 7 KB RForbes to previous | to last INCLUDE_ALL_IN_UEHN ==> INCLUDE_ALL_IN_UENH
12 26-Nov-2021 10:22 7 KB KHanson to previous | to last
11 26-Nov-2021 10:22 7 KB KHanson to previous | to last
10 26-Nov-2021 10:22 7 KB KHanson to previous | to last
9 26-Nov-2021 10:22 7 KB KHanson to previous | to last
8 26-Nov-2021 10:22 7 KB KHanson to previous | to last
7 26-Nov-2021 10:22 7 KB KHanson to previous | to last
6 26-Nov-2021 10:22 7 KB KHanson to previous | to last
5 26-Nov-2021 10:22 7 KB KHanson to previous | to last
4 26-Nov-2021 10:22 7 KB KHanson to previous | to last
3 26-Nov-2021 10:22 7 KB KHanson to previous | to last
2 26-Nov-2021 10:22 6 KB KHanson to previous | to last
1 26-Nov-2021 10:22 8 KB KHanson to last

Page References

Incoming links Outgoing links
IDLN
IDLN

Version management

Difference between version and

At line 1 changed 2 lines
!!!LOCATIONS
[{Image src='IDLN.JPG' width='360' align='right' link='attach/IDLN/IDLN.JPG'}]
[{TableOfContents }]
!!!DEFINE LOCATIONS
At line 13 added one line
At line 19 changed 2 lines
For example, the San Francisco headquarters may be a location with two sub-locations of the Berkley
and San Jose offices.
''For example, the San Francisco headquarters may be a location with two sub-locations of the Berkley and San Jose offices.''
At line 24 changed 2 lines
For example, the San Francisco headquarters may be divided into the general office, executive office
and shipping and receiving locations.
''For example, the San Francisco headquarters may be divided into the general office, executive office and shipping and receiving ocations.''
At line 27 changed 115 lines
The highest level of definition may be one location for the whole organization. The lowest level
of detail may be individual cubicles, workstations, telephone lines, etc. Lower levels of location
detail may be required if user-defined reporting such as generation of telephone listings,
safety/emergency maps and diagrams etc. are planned.
The locations where an employee works are used to determine the taxation jurisdiction
for calculating work taxes.
‘Define Locations’ Usage and Examples
Location data is stored in the P2K_CM_LOCATIONS table.
Location
This field holds the user-defined location code that uniquely identifies the locations to the
organization.
Locations may also be abstractions that are used in the delivery of pay checks/deposit
advices, when used as a "Pay Destination"
Location_Code is a 16-character alphanumeric mandatory field.
Part of
If the location is a sub-section of any higher-level location, the code for that higher-level
location will be held in this field.
Location_Code from P2K_CM_LOCATIONS is a 16-character alphanumeric optional field you may
either manually enter or retrieve from the LOV that has been previously defined.
Description
This field holds a short description of the location.
Description is a 50-character alphanumeric optional field.
The Bilingual component, including Bilingual Location, Language and CMA code as well
as bilingual region, is used exclusively for Canadian government reporting.
Bilingual Location
If this toggle is ON, the location is in a bilingual region. (E.g., Ottawa where both French
and English are working languages.)
Bilingual_Location is an optional toggle field.
Bilingual Region
For Canadian installations:
If the location is in a bilingual region, that region is indicated here.
Bilingual_Region is an optional field you may fill from the lexicon X_BILINGUAL_REGION
Language
This field holds the primary language used in the location. Even for bilingual regions, the
language that is most often used may be indicated in this field.
English will default
Language_Code is an optional fixed lexicon (X_LANGUAGE_CODE).
CMA Code
This field holds the CMA Code (Census Metropolitan Area) used in the locations.
CMA_Code is an optional user-defined lexicon (X_CMA_CODE).
Include All in UENH
The Create New Hires Interface File (UENH) allow you to create an interface file that
contains information on new hires, re-hires and employees who have returned to work from
an unpaid leave status within a specified period of time. You can decide to include the
employees who are returning to work by turning on the toggle "Include all in UENH". If this
toggle is off, only new hires and re-hires will be reported.
Address 1
‘Address 1’ provides the street address for the location.
Address_Line_1 is a 50-character alphanumeric optional field.
Address 2
‘Address 2’ provides the PO box number or suite number for the location.
Address_Line_2 is a 50-character alphanumeric optional field.
City/Town
This field provides the city, district or township of the location.
Locality is a 50-character alphanumeric optional field.
State/Province
This field displays the state or province description with the applicable country
concatenated at the end.
State_Province_Code from P2K_CM_STATE_PROVINCES is a 16-character alphanumeric
optional field.
Zip/Postal
This field will display the mailing code. The formatting (either Zip or Postal) will be
determined by the associated Country code.
U.S.A.: Zip Code. 55426
If the zip code you enter here has been defined as part of a zip code range on IDTX,
the system will automatically fill in the associated jurisdiction name in the next field.
In the case where a zip code is used in more than one jurisdiction, the system will
provide a list of jurisdictions for you to choose from.
Canada: Postal Code. M1M 1M1
Zip_Postal is a 16-character alphanumeric optional field.
GEO Tax Jurisdiction
‘Jurisdiction’ will display the GEO code of the city, county, state or province used for
taxation purposes.
Geo_Code from P2K_CM_TAX_JURISDICTION is a 16-character optional alphanumeric field.
Mailing Address 1
‘Address 1” is the street mailing address for the location.
Mail_Address_Line_1 is a 50-character alphanumeric optional field.
Mailing Address 2
‘Address 2’ is the PO box number or suite number mailing address for this location.
Mail_Address_Line_2 is a 50-character alphanumeric optional field.
Mailing City/Town
This field provides the city, district or township mailing address for this location.
Mail_Locality is a 50-character alphanumeric optional field.
Mailing State/Province
This field holds the state or province description with the applicable country concatenated
at the end.
State_Province_Code from P2K_CM_STATE_PROVINCES is a 16-character alphanumeric
mandatory field.
Mailing Zip/Postal
This field will display the mailing code. The formatting (either Zip or Postal) will be
determined by the associated Country code.
Mail_Zip_Postal is a 16-character alphanumeric optional field.
Phone #
‘Phone Number’ is the main phone number of the location.
The format of the phone number will be determined by the associated Country code.
Phone_Number is a 20-character optional alphanumeric field.
Extn
This field displays the extension for the main phone number.
Phone_Extension is a 16-character optional alphanumeric field.
Alt Phone #
This field displays an alternate phone number for this location.
Alt_Phone_Number is a 20-character optional alphanumeric field.
Alt Phone Ext.
This is the extension for the alternate phone number.
Alt_Phone_Extension is a 16-character optional alphanumeric field.
Fax #
This field holds the main fax number for this location.
Fax_Number is a 20-character optional alphanumeric field.
Email Address
This is the email address or domain name for the locations.
Email_Address
Subsidiary Locations
The information provided here is for display purposes only. If you need to change which
subsidiary locations appear here, or change the information provided for the subsidiary
location (e.g. phone number), you will need to access the specific record for the subsidiary
The highest level of definition may be one location for the whole organization. The lowest level of detail may be individual cubicles, workstations, telephone lines, etc. Lower levels of location detail may be required if user-defined reporting such as generation of telephone listings, safety/emergency maps and diagrams etc. are planned.
%%information The locations where an employee works are used to determine the taxation jurisdiction for calculating work taxes.%%
Location data is stored in the [P2K_CM_LOCATIONS] table.
;[Location | LOCATION_CODE]:This field holds the user-defined location code that uniquely identifies the locations to the organization. Locations may also be abstractions that are used in the delivery of pay checks/deposit advices, when used as a "Pay Destination"
;[Part of | PART_OF]:If the location is a sub-section of any higher-level location, the code for that higher-level location will be held in this field.
;[Description]:This field holds a short description of the location.
;:%%information The Bilingual component, including Bilingual Location, Language and CMA code as well as bilingual region, is used exclusively for Canadian government reporting.%%
;[Bilingual Location | BILINGUAL_LOCATION]:If this toggle is ON, the location is in a bilingual region. (E.g., Ottawa where both French and English are working languages.)
;[Bilingual Region | BILINGUAL_REGION]:For Canadian installations: If the location is in a bilingual region, that region is indicated here.
;[Language | LANGUAGE_CODE]:This field holds the primary language used in the location. Even for bilingual regions, the language that is most often used may be indicated in this field. English will default.
;[CMA Code | CMA_CODE]:This field holds the CMA Code (Census Metropolitan Area) used in the locations.
;[Include All in UENH |INCLUDE_ALL_IN_UEHN]:The Create New Hires Interface File ([UENH]) allow you to create an interface file that contains information on new hires, re-hires and employees who have returned to work from an unpaid leave status within a specified period of time. You can decide to include the employees who are returning to work by turning on the toggle Include all in [UENH]. If this toggle is off, only new hires and re-hires will be reported.
;[Address 1|ADDRESS_LINE_1]:‘Address 1’ provides the street address for the location.
;[Address 2|ADDRESS_LINE_2]:‘Address 2’ provides the PO box number or suite number for the location.
;[City/Town|LOCALITY]:This field provides the city, district or township of the location.
;[State/Province | STATE_PROVINCE_CODE]:This field displays the state or province description with the applicable country concatenated at the end.
;[Zip/Postal|ZIP_POSTAL]:This field will display the mailing code. The formatting (either Zip or Postal) will be determined by the associated Country code.
;:U.S.A.: Zip Code. 55426
;:%%information If the zip code you enter here has been defined as part of a zip code range on IDTX, the system will automatically fill in the associated jurisdiction name in the next field. In the case where a zip code is used in more than one jurisdiction, the system will provide a list of jurisdictions for you to choose from.%%
;:Canada: Postal Code. M1M 1M1
;[GEO Tax Jurisdiction | GEO_CODE]:'Jurisdiction' will display the GEO code of the city, county, state or province used for taxation purposes.
;[Mailing Address 1 | MAIL_ADDRESS_LINE_1]:‘Address 1” is the street mailing address for the location.
;[Mailing Address 2 | MAIL_ADDRESS_LINE_2]:‘Address 2’ is the PO box number or suite number mailing address for this location.
;[Mailing City/Town | MAIL_LOCALITY]:This field provides the city, district or township mailing address for this location.
;[Mailing State/Province | MAILING_STATE_PROVINCE]:This field holds the state or province description with the applicable country concatenated at the end.
;[Mailing Zip/Postal | MAIL_ZIP_POSTAL]:This field will display the mailing code. The formatting (either Zip or Postal) will be determined by the associated Country code.
;[Phone # | PHONE_NUMBER]:‘Phone Number’ is the main phone number of the location. The format of the phone number will be determined by the associated Country code.
;[Extn | PHONE_EXTENSION]:This field displays the extension for the main phone number.
;[Alt Phone # | ALT_PHONE_NUMBER]:This field displays an alternate phone number for this location.
;[Alt Phone Ext. | ALT_PHONE_EXTN]:This is the extension for the alternate phone number.
;[Fax # | FAX_NUMBER]:This field holds the main fax number for this location.
;[Email Address |EMAIL_ADDRESS(Field)]:This is the email address or domain name for the locations.
!!Subsidiary Locations
The information provided here is for display purposes only. If you need to change which subsidiary locations appear here, or change the information provided for the subsidiary location (e.g. phone number), you will need to access the specific record for the subsidiary
At line 143 removed 13 lines
Subsidiary Location
This field holds the Location_Code of any subsidiary locations for this location.
This information is created when the location has been identified within the “Part of
Location” field for another location.
For example, the location ‘AR-1st Floor’ is part of the location ‘Archives’. You can indicate this
relationship on the ‘AR-1’ record by going to the ‘Part of’ location field and either typing or looking up
‘Archives’. Once this is completed, if the record ‘Archives’ is retrieved, ‘AR-1st Floor’ will then appear
as a subsidiary location.
AR-1ST Floor
Description / Phone
The information for the ‘Description’, ‘Phone’ and ‘Phone Extension’ fields are derived from
the Location_Code record shown.
Client History (314) 466-2458 1545
At line 157 changed one line
%%warning This function is for viewing purposes only; you may not edit the data.%%
;Subsidiary Location:This field holds the Location_Code of any subsidiary locations for this location.
;:This information is created when the location has been identified within the “Part of Location” field for another location.
;:For example, the location ‘AR-1st Floor’ is part of the location ‘Archives’. You can indicate this relationship on the ‘AR-1’ record by going to the ‘Part of’ location field and either typing or looking up ‘Archives’. Once this is completed, if the record ‘Archives’ is retrieved, ‘AR-1st Floor’ will then appear as a subsidiary location.
;:AR-1ST Floor
At line 75 added 2 lines
;Description / Phone:The information for the ‘Description’, ‘Phone’ and ‘Phone Extension’ fields are derived from the Location_Code record shown.
;:Client History (314) 466-2458 1545
At line 78 added 2 lines
At line 82 added 5 lines
----
![Notes|Edit:Internal.IDLN]
[{InsertPage page='Internal.IDLN' default='Click to create a new notes page'}]
This page (revision-20) was last changed on 26-Nov-2021 10:22 by jmyersTop