PTIAMAINTLG_TBL(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
2 | UPDATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Update ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DTTM_IMPORTED | DateTime(26) | TIMESTAMP | Imported Date Time |
5 | FIXOPRID | Character(30) | VARCHAR2(30) NOT NULL | User that Created Update |
6 | APPLYOPRID | Character(30) | VARCHAR2(30) NOT NULL | User that Applied Update |
7 | PRODUCT_LINE | Character(10) | VARCHAR2(10) NOT NULL | Product Line |
8 | RELEASEDTTM | DateTime(26) | TIMESTAMP | Release Date/Time |
9 | 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 |
10 | MAINTLOGTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Log Type
CAIP=CA Job Started CAOK=CA Job Successful CAOV=Override Requisite IDEC=IDE Project Copy NPID=Non-Primary Update NPIP=Non-Primary Update IP USR1=User Applied |