RO_DEFNLNSTLNVW (SQL View)	Index Back
Line Status This record is a view which contains the inforamtion of line status

RO_DEFNLNSTLNVW

(SQL View)

Line Status

This record is a view which contains the inforamtion of line status

SELECT SETID ,STATUS_CODE , LANGUAGE_CD , DESCR50 FROM %Table(RO_DEFNLNST_LNG)

Related Language Record for RO_DEFN_LNST_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 STATUS_CODE_LINE Number(5,0) INTEGER NOT NULL Field used as number field for Status Code. Mostly used in correxpondance management

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

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	STATUS_CODE_LINE	Number(5,0)	INTEGER NOT NULL	Field used as number field for Status Code. Mostly used in correxpondance management
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50