PROCESS_INSTANCEGPFR_DUCS_NUMBERGPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_ROW_NUMGPFR_DUCS_REG_FLGY/N Table Edit
Default Value: N
1=Try
Default Value: %Datetime
GPFR_DUCS_DEB(SQL Table) |
Index Back |
|---|---|
Result DUCS DEB SegmentHeader of each declaration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPFR_DUCS_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 3 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 4 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 5 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 6 | GPFR_DUCS_REG_FLG |
Character(1) | VARCHAR2(1) NOT NULL |
DUCS Regularization Flag
Y/N Table Edit Default Value: N |
| 7 | GPFR_DUCS_RECORD | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Record Code |
| 8 | GPFR_DUCS_DEB_FRID | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Transmitter ID |
| 9 | GPFR_DUCS_DEB_FRCD | Character(4) | VARCHAR2(4) NOT NULL | GPFR: Transmitter ID Type |
| 10 | GPFR_DUCS_DEB_MRID | Character(35) | VARCHAR2(35) NOT NULL | GPFR: Receiver ID |
| 11 | GPFR_DUCS_DEB_MRCD | Character(4) | VARCHAR2(4) NOT NULL | GPFR: Receiver ID Type |
| 12 | GPFR_DUCS_DEB_DATE | Character(8) | VARCHAR2(8) NOT NULL | GPFR: Date of the DUCS |
| 13 | GPFR_DUCS_DEB_HOUR | Character(4) | VARCHAR2(4) NOT NULL | GPFR: Hour |
| 14 | GPFR_DUCS_DEB_TEST | Character(1) | VARCHAR2(1) NOT NULL |
On the DEB record, Space means it's a real declaration, '1' means it's a try.
1=Try |
| 15 | GPFR_DUCS_DEB_MESS | Character(6) | VARCHAR2(6) NOT NULL | GPFR: Message Identification |
| 16 | GPFR_DUCS_DEB_UNSM | Character(3) | VARCHAR2(3) NOT NULL | GPFR: COPAYM |
| 17 | GPFR_DUCS_DEB_V1 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: COPAYM Version |
| 18 | GPFR_DUCS_DEB_REF | Character(35) | VARCHAR2(35) NOT NULL | GPFR: DUCS Declaration Reference |
| 19 | GPFR_DUCS_DEB_SLIP | Character(3) | VARCHAR2(3) NOT NULL | GPFR: Slip Type |
| 20 | GPFR_DUCS_DEB_V2 | Character(3) | VARCHAR2(3) NOT NULL | GPFR: COPLAT Version |
| 21 | GPFR_DUCS_DEB_EDT | Character(3) | VARCHAR2(3) NOT NULL | GPFR: COPLAT Edition Number |
| 22 | GPFR_ASS_DATETIME | DateTime(26) | TIMESTAMP |
GPFR: DateTime
Default Value: %Datetime |
| 23 | BGN_DT | Date(10) | DATE | Begin Date |
| 24 | END_DT | Date(10) | DATE | end date |
| 25 | GPFR_DUCS_DEB_RCE | Character(14) | VARCHAR2(14) NOT NULL | DUCS DEB Common Exchange Reference |
| 26 | GPFR_DUCS_DEB_SOFT | Character(20) | VARCHAR2(20) NOT NULL | DUCS DEB Payroll Software |
| 27 | GPFR_DUCS_DEB_SVDR | Character(20) | VARCHAR2(20) NOT NULL | DUCS DEB Software Vendor |
| 28 | GPFR_DUCS_DEB_SVER | Character(10) | VARCHAR2(10) NOT NULL | DUCS DEB Software Version |
| 29 | GPFR_DUCS_DEB_REG | Character(3) | VARCHAR2(3) NOT NULL | DUCS DEB Regularization |
| 30 | GPFR_DUCS_DEB_REGN | Character(1) | VARCHAR2(1) NOT NULL | DUCS DEB Regularization Number |