BUSINESS_UNITSOURCE_BUS_UNITACTION_CDC=Copy
D=Delete
R=Rename
ITEM_IDGL_BU_QS_AS(SQL Table) |
Index Back |
|---|---|
GL BU Question Answer |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 3 | ACTION_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Action Code
C=Copy D=Delete R=Rename |
| 4 | ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 5 | QS_ID | Character(31) | VARCHAR2(31) NOT NULL | Questionnaire ID |
| 6 | QUES_ANS | Character(1) | VARCHAR2(1) NOT NULL | Question answer |