CF_SOURCE_TBL(SQL Table) |
Index Back |
---|---|
Chartfield Value Mapping |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | VALUE_SET_NAME | Character(10) | VARCHAR2(10) NOT NULL | Value Set Name |
2 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL |
ChartField
Prompt Table: CHARTFIELD_VW |
3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
4 | SETID_FROM | Character(5) | VARCHAR2(5) NOT NULL | SetID From |
5 | RANGE_FROM | Character(30) | VARCHAR2(30) NOT NULL | Lower boundary for detail value that contains a range of values |
6 | RANGE_TO | Character(30) | VARCHAR2(30) NOT NULL | Upper boundary for detail value that contains a range of values |