STATESTATE_LOCATION_MEXADDRESS4STA_LOC_TBL_MEX(SQL Table) |
Index Back |
|---|---|
STPS Report State LocationSTPS Report State Location Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | STATE_LOCATION_MEX |
Number(3,0) | SMALLINT NOT NULL | State Location |
| 3 | ADDRESS4 |
Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 4 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL | This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. |