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
Set Control Field: RELEASELABEL

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