FF_DSCOL_CALVAL(SQL Table) |
Index Back |
|---|---|
Flat file aggregate valuesFlat file aggregate values |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FF_FILE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Flat file name |
| 2 | FF_VERSION |
Character(30) | VARCHAR2(30) NOT NULL | Message Version |
| 3 | FF_SECTIONID |
Character(30) | VARCHAR2(30) NOT NULL | Flat file section type |
| 4 | FF_SECTIONTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Flat file section type
1=Header 2=Detail 3=Group 4=Trailer |
| 5 | FF_SUBSECTION |
Character(1) | VARCHAR2(1) NOT NULL |
Flat file subsection type
A=Additional Record D=Group Detail H=Group Header N=None T=Group Trailer |
| 6 | FF_DSCOLFLD |
Character(30) | VARCHAR2(30) NOT NULL | Flat file data source field |
| 7 | FF_AGGREGATE | Character(1) | VARCHAR2(1) NOT NULL |
Flat file Aggregate
A=Average C=Count M=Minimum S=Sum X=Maximum |
| 8 | FF_AGGSECTIONID | Character(30) | VARCHAR2(30) NOT NULL |
Flat file section type
Prompt Table: FF_SEC_NAME_VW |
| 9 | FF_AGGCOLFLD | Character(30) | VARCHAR2(30) NOT NULL |
Flat file data source field
Prompt Table: FF_COL_FLD_DVW |
| 10 | FF_AGGCOLNAME | Character(254) | VARCHAR2(254) NOT NULL | Flat file data source column |
| 11 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |