PROCESS_INSTANCEGPJP_SC_HDR_FD(SQL Table) |
Index Back |
|---|---|
FD Control Header Work RecordFD Control Header Work Record for the AE program GPJP_SC_RPT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPJP_PREFECTURE_CD | Character(2) | VARCHAR2(2) NOT NULL | Prefecture Code |
| 3 | GPJP_SC_ESTAB_REF1 | Character(10) | VARCHAR2(10) NOT NULL | Establishment Reference Number. |
| 4 | GPJP_SC_ESTAB_REF2 | Character(10) | VARCHAR2(10) NOT NULL | Establishment Reference Number 2. |
| 5 | GPJP_FD_SEQ | Number(3,0) | SMALLINT NOT NULL | FD Sequential Number |
| 6 | GPJP_CREATE_DT | Date(10) | DATE | File Creation Date |
| 7 | GPJP_CHAR4_1 | Character(4) | VARCHAR2(4) NOT NULL | Character Field of Length 4. |