2Community Development

Import Agency Staff

Imports Agency Staff into the PSCR master tables.

Details

• Object owner: PSC-Public Sector Common Components

• UCM account: psc/commoncomponents/import

File Links

File	Link
XLSM template	AgencyStaffImportTemplate.xlsm
Control files	Agency Staff generic attributes Import Control File Agency Staff Job attributes Import Control File Agency Staff Access Import Control File

Job and Table Links

Name	Link
Scheduled process	Import Agency Staff
Tables	PSC_COM_JOB_ASGT_INT PSC_COM_PRSN_ACS_INT PSC_COM_PRSN_PRFL_INT

Import Property Information

Imports property information into the PSCR parcel master tables.

Details

• Object owner: PSC-Public Sector Common Components

• UCM account: psc/commoncomponents/import

File Links

File	Link
XLSM template	AddressParcelOwnerImportTemplate.xlsm
Control files	Parcel Import Control File Owner Import Control File Address Import Control File Value Import Control File

Job and Table Links

Name	Link
Scheduled process	Import Property Information
Tables	PSC_COM_PARCEL_ADDRESS_INT PSC_COM_PARCEL_INT PSC_COM_PARCEL_OWNER_INT PSC_COM_PARCEL_VALUE_INT