Forums

Administration & IT NSCAN Profiles - Facility String

NSCAN Profiles - Facility String

Rachel Stone $organization over 5 years ago

Hi, all-

Does anyone know if there is a limit as to how many facilities can be included in the facility string in TR_NSCAN_PROFILES?

I cannot add any more so I have apparently hit whatever the limit is (unless something else is going on...) and trying to figure out how to proceed.

Thanks very much.

Rachel

Parents

Jerry Boutot $organization over 5 years ago

Hi Rachel,

The facility_str field is varchar(100) – so 100 characters max, counting digits and commas. Assuming 3 digits each, that’s 25 facilities. Do you need that many all at once?

Jerry Boutot | Manager, Information Technology - Data

O: 813.222.1097 C: 352-428-4199
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Jerry Boutot $organization over 5 years ago

Hi Rachel,

The facility_str field is varchar(100) – so 100 characters max, counting digits and commas. Assuming 3 digits each, that’s 25 facilities. Do you need that many all at once?

Jerry Boutot | Manager, Information Technology - Data

O: 813.222.1097 C: 352-428-4199
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Rachel Stone $organization over 5 years ago in reply to Jerry Boutot

Thanks for your quick reply Jerry! No, not needed all at once, just thought it would be easier to have them all listed so we don't have to make changes throughout the season. That said, not a big deal to have to adjust periodically. Thanks again!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel