PROCESS_NAMESQR_REPORT(SQL Table) |
Index Back |
|---|---|
SQR Report DefinitionSQR Report Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 2 | REPORT_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Report Title |
| 3 | FIX_001_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_001_LENGTH |
| 4 | FIX_002_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_002_LENGTH |
| 5 | FIX_003_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_003_LENGTH |
| 6 | FIX_004_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_004_LENGTH |
| 7 | FIX_005_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_005_LENGTH |
| 8 | FIX_006_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_006_LENGTH |
| 9 | FIX_007_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_007_LENGTH |
| 10 | FIX_008_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_008_LENGTH |
| 11 | FIX_009_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_009_LENGTH |
| 12 | FIX_010_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_010_LENGTH |
| 13 | FIX_011_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_011_LENGTH |
| 14 | FIX_012_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_012_LENGTH |
| 15 | FIX_013_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_013_LENGTH |
| 16 | FIX_014_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_014_LENGTH |
| 17 | FIX_015_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_015_LENGTH |
| 18 | FIX_016_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_016_LENGTH |
| 19 | FIX_017_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_017_LENGTH |
| 20 | FIX_018_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_018_LENGTH |
| 21 | FIX_019_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_019_LENGTH |
| 22 | FIX_020_LENGTH | Number(3,0) | SMALLINT NOT NULL | FIX_020_LENGTH |
| 23 | SUM_001_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_001_LENGTH |
| 24 | SUM_002_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_002_LENGTH |
| 25 | SUM_003_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_003_LENGTH |
| 26 | SUM_004_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_004_LENGTH |
| 27 | SUM_005_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_005_LENGTH |
| 28 | SUM_006_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_006_LENGTH |
| 29 | SUM_007_LENGTH | Number(3,0) | SMALLINT NOT NULL | SUM_007_LENGTH |
| 30 | HDG_001_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_001_ADJUST |
| 31 | HDG_002_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_002_ADJUST |
| 32 | HDG_003_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_003_ADJUST |
| 33 | HDG_004_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_004_ADJUST |
| 34 | HDG_005_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_005_ADJUST |
| 35 | HDG_006_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_006_ADJUST |
| 36 | HDG_007_ADJUST | Number(3,0) | SMALLINT NOT NULL | HDG_007_ADJUST |
| 37 | LEVEL1_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 1 Name |
| 38 | LEVEL2_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 2 Name |
| 39 | LEVEL3_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 3 Name |
| 40 | LEVEL4_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 4 Name |
| 41 | LEVEL5_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 5 Name |
| 42 | LEVEL6_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 6 Name |
| 43 | LEVEL7_NAME | Character(20) | VARCHAR2(20) NOT NULL | Break Level 7 Name |
| 44 | FIX_001_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_001_HDG_LINE1 |
| 45 | FIX_002_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_002_HDG_LINE1 |
| 46 | FIX_003_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_003_HDG_LINE1 |
| 47 | FIX_004_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_004_HDG_LINE1 |
| 48 | FIX_005_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_005_HDG_LINE1 |
| 49 | FIX_006_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_006_HDG_LINE1 |
| 50 | FIX_007_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_007_HDG_LINE1 |
| 51 | FIX_008_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_008_HDG_LINE1 |
| 52 | FIX_009_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_009_HDG_LINE1 |
| 53 | FIX_010_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_010_HDG_LINE1 |
| 54 | FIX_011_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_011_HDG_LINE1 |
| 55 | FIX_012_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_012_HDG_LINE1 |
| 56 | FIX_013_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_013_HDG_LINE1 |
| 57 | FIX_014_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_014_HDG_LINE1 |
| 58 | FIX_015_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_015_HDG_LINE1 |
| 59 | FIX_016_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_016_HDG_LINE1 |
| 60 | FIX_017_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_017_HDG_LINE1 |
| 61 | FIX_018_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_018_HDG_LINE1 |
| 62 | FIX_019_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_019_HDG_LINE1 |
| 63 | FIX_020_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | FIX_020_HDG_LINE1 |
| 64 | FIX_001_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_001_HDG_LINE2 |
| 65 | FIX_002_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_002_HDG_LINE2 |
| 66 | FIX_003_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_003_HDG_LINE2 |
| 67 | FIX_004_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_004_HDG_LINE2 |
| 68 | FIX_005_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_005_HDG_LINE2 |
| 69 | FIX_006_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_006_HDG_LINE2 |
| 70 | FIX_007_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_007_HDG_LINE2 |
| 71 | FIX_008_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_008_HDG_LINE2 |
| 72 | FIX_009_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_009_HDG_LINE2 |
| 73 | FIX_010_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_010_HDG_LINE2 |
| 74 | FIX_011_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_011_HDG_LINE2 |
| 75 | FIX_012_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_012_HDG_LINE2 |
| 76 | FIX_013_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_013_HDG_LINE2 |
| 77 | FIX_014_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_014_HDG_LINE2 |
| 78 | FIX_015_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_015_HDG_LINE2 |
| 79 | FIX_016_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_016_HDG_LINE2 |
| 80 | FIX_017_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_017_HDG_LINE2 |
| 81 | FIX_018_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_018_HDG_LINE2 |
| 82 | FIX_019_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_019_HDG_LINE2 |
| 83 | FIX_020_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | FIX_020_HDG_LINE2 |
| 84 | HDG_001_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_001_HDG_LINE1 |
| 85 | HDG_002_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_002_HDG_LINE1 |
| 86 | HDG_003_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_003_HDG_LINE1 |
| 87 | HDG_004_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_004_HDG_LINE1 |
| 88 | HDG_005_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_005_HDG_LINE1 |
| 89 | HDG_006_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_006_HDG_LINE1 |
| 90 | HDG_007_HDG_LINE1 | Character(20) | VARCHAR2(20) NOT NULL | HDG_007_HDG_LINE1 |
| 91 | HDG_001_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_001_HDG_LINE2 |
| 92 | HDG_002_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_002_HDG_LINE2 |
| 93 | HDG_003_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_003_HDG_LINE2 |
| 94 | HDG_004_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_004_HDG_LINE2 |
| 95 | HDG_005_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_005_HDG_LINE2 |
| 96 | HDG_006_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_006_HDG_LINE2 |
| 97 | HDG_007_HDG_LINE2 | Character(20) | VARCHAR2(20) NOT NULL | HDG_007_HDG_LINE2 |