FP_YEARSEXF=Female
M=Male
U=Unknown
FP_BIRTHYEARAGEFPAHEADCNT03(SQL Table) |
Index Back |
|---|---|
Age and Age grouping TableAge and Age grouping Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Year |
| 2 | SEX |
Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 3 | FP_BIRTHYEAR |
Character(4) | VARCHAR2(4) NOT NULL | Birthyear |
| 4 | AGE |
Number(3,0) | SMALLINT NOT NULL | Age |
| 5 | FP_SIZE | Character(2) | VARCHAR2(2) NOT NULL | Age Group Width |
| 6 | FP_TRANCHE_AGE | Character(5) | VARCHAR2(5) NOT NULL | Age Group |
| 7 | FP_HEADCNT | Number(12,3) | DECIMAL(11,3) NOT NULL | Headcount |