STATEVARTL_STATE_VARS(SQL View) |
Index Back |
|---|---|
State Variable Table |
| SELECT DISTINCT %TrimSubstr(A.RECNAME,1,15) %Concat '.' %Concat A.FIELDNAME FROM PS_TL_RECFIELD_TBL A , PS_TL_WORK_TABLES B WHERE A.RECNAME = B.RECNAME AND B.STATEREC_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATEVAR |
Character(35) | VARCHAR2(35) NOT NULL | State Variable |