RUN_CAEDD_PRCS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 4 | FEDERAL_EIN | Number(9,0) | DECIMAL(9) NOT NULL |
Federal EIN
Prompt Table: CAEDD_CNTRL |
| 5 | CAEDD_MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Media Type
C=CD-Recordable D=Diskette E=Cartridge (3480) N=Cartridge (3490) T=Magnetic Tape (9 Track) Default Value: D |
| 6 | INTERNAL_LABEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Internal Label Flag
Y/N Table Edit Default Value: N |
| 7 | DISKETTE_SIZE | Character(1) | VARCHAR2(1) NOT NULL |
Diskette Size
F=5 1/4 Inch T=3 1/2 Inch Default Value: T |