PROCESS_INSTANCESRF_SRC_IS_BCN=No
Y=Yes
SRF_SRC_FH_FT(SQL Table) |
Index Back |
|---|---|
SRF_SRC_FH_FTDEIU source table for FH and FT records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SRF_SRC_IS_BC |
Character(1) | VARCHAR2(1) NOT NULL |
PIR SRF source is BC
N=No Y=Yes |
| 3 | USF_PIR_NAME | Character(40) | VARCHAR2(40) NOT NULL | PIR Input System Name |
| 4 | PIR_VERSION_ID | Character(3) | VARCHAR2(3) NOT NULL | PIR Version ID |
| 5 | SRF_FT_TOT_CNT_REC | Character(18) | VARCHAR2(18) NOT NULL | TotalCount_Records |
| 6 | SRF_FT_TOT_COUNT | Character(18) | VARCHAR2(18) NOT NULL | TotalCount |
| 7 | SRF_FT_TOT_AMOUNT | Character(20) | VARCHAR2(20) NOT NULL | TotalAmount |