PTIASPSRCINFO

index back

BUG Source Info

This is a one row table with basic information about this patching source database

PeopleSoft Field Name Field Type Column Type Description
PTIASPLICGRP Character(18) VARCHAR2(18) NOT NULL This is the database License Group for example FIN/SCM or HRMS
PTIASPAPPVERSION Character(15) VARCHAR2(15) NOT NULL Application Version including point release eg 9.2
PTIASPLOCALIZATN Character(2) VARCHAR2(2) NOT NULL Localization for this database eg BR or AR
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPSPIDATE Date(10) DATE Date that the image was created
PTIASPIMAGETYPE Character(1) VARCHAR2(1) NOT NULL Image Type
E=External
I=Internal
M=Master
P=PI/PRP
PTIASPTMPLTVERS Number(5,0) INTEGER NOT NULL Template Version
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20