EXTRACT_PROGRAMC=Compensation Amount
P=Payroll Amount
TC_EXT_MEASR_VW(SQL View) |
Index Back |
|---|---|
TC view for related displayTotal Compensation View for related display in extract run control |
| SELECT DISTINCT EXTRACT_PROGRAM, TC_MEASURE FROM PS_TC_COMP_SOURCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXTRACT_PROGRAM |
Character(12) | VARCHAR2(12) NOT NULL | Extract Program |
| 2 | TC_MEASURE | Character(1) | VARCHAR2(1) NOT NULL |
Amount Type
C=Compensation Amount P=Payroll Amount |