PTIASPTARGETS(SQL Table) |
Index Back |
|---|---|
Selective Patching target DBs |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 2 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 3 | RELEASELABEL | Character(50) | VARCHAR2(50) NOT NULL |
Release Label
00=Core 10=Education and Government 18=Service Industries 19=Comm., Transportation & Util 20=Retail 21=Performance Measurement 22=HealthCare 23=Student Administration 25=U.S. Federal Govt 26=Canadian Govt 30=Intl Translations 32=Netherlands 33=United Kingdom 34=Espanol/Spain 35=France 36=Portuguese 37=Italy 39=German 50=South Africa 60=Latin America Local 61=Mexico 62=Argentina 63=Brazil 81=Japanese 88=Asia/Pacific 99=PeopleSoft Select |
| 4 | PTIASPTOOLSMAJOR | Number(8,2) | DECIMAL(7,2) NOT NULL |
PeopleTools Major Release
Default Value: 0 |
| 5 | PTIASPTOOLSMINOR | Number(5,0) | INTEGER NOT NULL |
PeopleTools Minor Release
Default Value: 0 |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |