PSIMPFIELD(SQL Table) |
Index Back |
---|---|
Import Field |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IMPNAME | Character(18) | VARCHAR2(18) NOT NULL | Import Definition Name (see PSIMPDEFN). |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
3 | STARTLOC | Number(5,0) | INTEGER NOT NULL | Start Location |
4 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
5 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
6 | DATETYPE | Number(2,0) | SMALLINT NOT NULL | Date Type |
7 | BYPASS | Number(5,0) | INTEGER NOT NULL | Bypass |
8 | IMPDEFAULT | Character(18) | VARCHAR2(18) NOT NULL | Import Default |
9 | XLATCOUNT | Number(5,0) | INTEGER NOT NULL | Import Translate Count |