SF1219_STRNG_VW

(SQL View)
 Index Back

SF 1219 Report Lines View

This view uses data stored in the Strings Table

SELECT STRING_ID , STRING_TEXT FROM PS_STRINGS_TBL WHERE PROGRAM_ID = 'GLSF1219' AND STRING_ID NOT IN ('1.00','2.00','2.30','2.90','3.00','4.00','4.30','4.90','5.00','7.10','7.20','7.30','7.40','8.00','9.00','9.90') AND STRING_TEXT <> '#'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID

Prompt Table: STRINGS_DBF_VW

2 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text