PSOPRVERDPLYDAT(SQL Table) |
Index Back |
---|---|
IB Operation Verion Deploy Dat |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
2 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL |
Service Operation Version
Prompt Table: PSSRVVERDFN2_VW |
3 | IB_APP_PILLAR | Character(10) | VARCHAR2(10) NOT NULL | Application Pillar |
4 | 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 Prompt Table:
IB_REL_LOOKUP
|
5 | IB_DIRECTION | Character(1) | VARCHAR2(1) NOT NULL |
Direction
F=Fault I=Inbound O=Outbound Default Value: I |
6 | IB_APP_LOOKUP | Character(30) | VARCHAR2(30) NOT NULL | Application Lookup |
7 | ALIASNAME | Character(254) | VARCHAR2(254) NOT NULL | External Alias |
8 | IB_SYNCHNONBLOCK | Character(1) | VARCHAR2(1) NOT NULL | User Exception |
9 | IB_UNORDER_SEGMENT | Character(1) | VARCHAR2(1) NOT NULL |
Unorder Segments
N=No Y=Yes |
10 | XFRMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 1
Prompt Table: PSRELTRNSFRMVW |
11 | XFRMNAME_SECOND | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 2
Prompt Table: PSRELTRNSFRMVW |
12 | INMSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
13 | INMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL |
In Message Version
Prompt Table: PSMSGDEFN_VW4 |
14 | OUTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
15 | OUTMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL |
Out Message Version
Prompt Table: PSMSGDEFN_VW5 |
16 | ONSNDHDLRNAME | Character(30) | VARCHAR2(30) NOT NULL |
OnSend Handler
Prompt Table: PSSRVHDLRSND_VW |
17 | ONRCVHDLRNAME | Character(30) | VARCHAR2(30) NOT NULL |
OnReceive Handler
Prompt Table: PSSRVHDLRRCV_VW |
18 | ONPREHDLRNAME | Character(30) | VARCHAR2(30) NOT NULL |
OnPreNotify Handler
Prompt Table: PSSRVHDLRPRN_VW |
19 | ONPOSTHDLRNAME | Character(30) | VARCHAR2(30) NOT NULL |
OnPostNotify Handler
Prompt Table: PSSRVHDLRPTN_VW |
20 | XFRMNAME_R | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 1
Prompt Table: PSRELTRNSFRMVW |
21 | XFRMNAME_SECOND_R | Character(30) | VARCHAR2(30) NOT NULL |
Transform Program 2
Prompt Table: PSRELTRNSFRMVW |
22 | INMSGNAME_R | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
23 | INMSGVERSION_R | Character(30) | VARCHAR2(30) NOT NULL |
In Message Version
Prompt Table: PSMSGDEFN_VW7 |
24 | OUTMSGNAME_R | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition.
Prompt Table: PSMSGDEFN |
25 | OUTMSGVERSION_R | Character(30) | VARCHAR2(30) NOT NULL |
Out Message Version
Prompt Table: PSMSGDEFN_VW8 |