PGM_APPL_AC_LG (SQL View)	Index Back
Active Applications Language Language view for PGM_APPLICAT_AC prompt view. This is the prompt view for selecting all active Applications.

PGM_APPL_AC_LG

(SQL View)

Active Applications Language

Language view for PGM_APPLICAT_AC prompt view. This is the prompt view for selecting all active Applications.

SELECT A.SETID , A.APPLICATION_AREA , A.APPLICATION , L.LANGUAGE_CD , L.DESCR FROM PS_PGM_APPLICATION A , PS_PGM_APPLICAT_LG L WHERE A.SETID = L.SETID AND A.APPLICATION = L.APPLICATION AND A.EFF_STATUS = 'A'

Related Language Record for PGM_APPLICAT_AC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
Prompt Table: PGM_APPLAREA_AC

3 APPLICATION Character(10) VARCHAR2(10) NOT NULL Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	APPLICATION_AREA	Character(10)	VARCHAR2(10) NOT NULL	The general area in which an application belongs. Examples: "Financials", "Human Resources", etc. Prompt Table: PGM_APPLAREA_AC
3	APPLICATION	Character(10)	VARCHAR2(10) NOT NULL	Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description