EX_TXSTAT_L_VW2 (SQL View)	Index Back
Translate Value View - Mobile Translate view used to extract Transaction Status for Mobile MTE 8.8

EX_TXSTAT_L_VW2

(SQL View)

Translate Value View - Mobile

Translate view used to extract Transaction Status for Mobile MTE 8.8

SELECT A.FIELDNAME ,%Substring(A.FIELDVALUE,1,1) , B.LANGUAGE_CD , B.XLATLONGNAME , A.LASTUPDDTTM FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDVALUE NOT IN ('R', 'D') AND %Join(COMMON_KEYS, PSXLATITEM A, PSXLATITEMLANG B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Assigned
D=Marked for Delete
R=Rejected
T=All Transaction Statuses
U=Unassigned

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

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

5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	TXN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.