RQRMNT_USE_TBVW(SQL View) |
Index Back |
---|---|
View to select 4 digit rq useaView that selects only those requirement useages that have four characters. |
SELECT RQRMNT_USE_VAL, EFFDT, SPECIAL_REPT_TYPE, DESCR FROM PS_RQRMNT_USE_TBL WHERE %SUBSTRING(RQRMNT_USE_VAL, 1, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 2, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 3, 1) <> ' ' and %SUBSTRING(RQRMNT_USE_VAL, 4, 1) <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RQRMNT_USE_VAL | Character(4) | VARCHAR2(4) NOT NULL | Requirement Usage |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | SPECIAL_REPT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Special Report
NO=No Special Formatting SPC=Special Report Format |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |