SCOPE_MAP_TYPEPSFIELD_SEQ_NBRDP_FLD_XREF(SQL Table) |
Index Back |
|---|---|
PS fields referencePS fields reference |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCOPE_MAP_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Import Map Type |
| 2 | PSFIELD_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | PeopleSoft Field Sequence Nbr |
| 3 | PSTABLE_NAME | Character(15) | VARCHAR2(15) NOT NULL | PS Table Name |
| 4 | PSFIELD_NAME | Character(18) | VARCHAR2(18) NOT NULL | PS Field Name |
| 5 | PSFIELD_DOWN_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Download Type |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | FIELD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Field Length |