RO_DEFNLNSTLNVW(SQL View) |
Index Back |
---|---|
Line StatusThis record is a view which contains the inforamtion of line status |
SELECT SETID ,STATUS_CODE , LANGUAGE_CD , DESCR50 FROM %Table(RO_DEFNLNST_LNG) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 | Number(5,0) | INTEGER NOT NULL | Field used as number field for Status Code. Mostly used in correxpondance management | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |