PTLT_INSTALL(SQL Table) |
Index Back |
|---|---|
Setup Manager - InstallationInstallation Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_PACKAGE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Determines whether or not a customer or developer is using our tool. C = customer D = developer |
| 2 | PTLT_PK_ACTIVITY | Character(20) | VARCHAR2(20) NOT NULL | SRP Activity |
| 3 | PTLT_BP_VERSION | Number(5,0) | INTEGER NOT NULL | Business Process Version |
| 4 | PTLT_TASKSEQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | Task Sequence |
| 5 | 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 |
| 6 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |