FE_MGR_REP_DAT(SQL Table) |
Index Back |
|---|---|
Reporting Chg Transaction DataContains transactional data for fed SS reporting change |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 2 | ACTION_DT_SS | Date(10) | DATE NOT NULL | Reporting Change Date |
| 3 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table: PERSON_NAME |
| 4 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table: POSITION_DATA |
| 5 | EMPL_NAME | Character(50) | VARCHAR2(50) NOT NULL | Employee Name |
| 6 | COMMENTS | Long Character | CLOB | Comment |
| 7 | TRANSACTION_NAME | Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 8 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
| 9 | UPD_BY_USERID | Character(30) | VARCHAR2(30) NOT NULL | Used on "_DAT" records for 8.3 Workflow Enhancements |
| 10 | UPD_DTTM | DateTime(26) | TIMESTAMP | Used on "_DAT" records for 8.3 Workflow Enhancements |
| 11 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 12 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 13 | GVT_LEG_AUTH_1 | Character(3) | VARCHAR2(3) NOT NULL | Legal Authority (1) |
| 14 | GVT_LEG_AUTH_2 | Character(3) | VARCHAR2(3) NOT NULL | Legal Authority (2) |
| 15 | GVT_SF50_REMARK | Character(3) | VARCHAR2(3) NOT NULL | SF50 Remark Code |
| 16 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 17 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|