PSIBAPPEXPRT_VW (SQL View)	Index Back
Application Service Defn Application Service - view for export services: - service must be active, Master, provider only

PSIBAPPEXPRT_VW

(SQL View)

Application Service Defn

Application Service - view for export services: - service must be active, Master, provider only

SELECT PTIBAPPLNAME , PTIB_EXPORT , PTIBAPPLTYPE , STATUS FROM PSIBAPPLDEFN WHERE PTIBAPPLTYPE = 'M' AND STATUS = 'A' and PTIB_CONSUMER = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).

2 PTIB_EXPORT Character(1) VARCHAR2(1) NOT NULL Export Service
N=No Export
Y=Export Service

3 PTIBAPPLTYPE Character(1) VARCHAR2(1) NOT NULL Field to denote whether a service is master or Alias
A=Alias Service
M=Primary Service
Default Value: M

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTIBAPPLNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Service ID. (see PSIBAPPLDEFN).
2	PTIB_EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Service N=No Export Y=Export Service
3	PTIBAPPLTYPE	Character(1)	VARCHAR2(1) NOT NULL	Field to denote whether a service is master or Alias A=Alias Service M=Primary Service Default Value: M
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A