WTHD_C_RECORD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECORD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Record Type
F=Project Funding R=Project Resource Transaction |
| 2 | C_NBR_OF_PAYEES | Character(8) | VARCHAR2(8) NOT NULL | Number of Payees |
| 3 | BLANK6 | Character(6) | VARCHAR2(6) NOT NULL | 6 Blanks |
| 4 | C_CONTROL_TOTAL_1 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 5 | C_CONTROL_TOTAL_2 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 6 | C_CONTROL_TOTAL_3 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 7 | C_CONTROL_TOTAL_4 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 8 | C_CONTROL_TOTAL_5 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 9 | C_CONTROL_TOTAL_6 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 10 | C_CONTROL_TOTAL_7 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 11 | C_CONTROL_TOTAL_8 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 12 | C_CONTROL_TOTAL_9 | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 13 | C_CONTROL_TOTAL_A | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 14 | C_CONTROL_TOTAL_B | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 15 | C_CONTROL_TOTAL_C | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 16 | C_CONTROL_TOTAL_D | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 17 | C_CONTROL_TOTAL_E | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 18 | C_CONTROL_TOTAL_F | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 19 | C_CONTROL_TOTAL_G | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 20 | C_CONTROL_TOTAL_H | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 21 | C_CONTROL_TOTAL_J | Character(18) | VARCHAR2(18) NOT NULL | Control Total |
| 22 | BLANK160 | Character(160) | VARCHAR2(160) NOT NULL | BLANK |
| 23 | REC_SEQ_NBR | Character(8) | VARCHAR2(8) NOT NULL | Record Sequence Number |
| 24 | BLANK241 | Character(241) | VARCHAR2(241) NOT NULL | blank |
| 25 | BLANK2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |