TC_PLAN_IDTC_PLAN_EFFDTGB_GROUP_IDEMPLIDEMPL_RCDTHRU_DATETC_POPULATION_V(SQL View) |
Index Back |
|---|---|
TC Plan Population ViewTC Plan Population View |
| SELECT TC_PLAN_ID , %DateOut(TC_PLAN_EFFDT) , GB_GROUP_ID , EMPLID , EMPL_RCD , %DateOut(THRU_DATE) , %DateOut(FROM_DATE) , %DateOut(JOB_EFFDT) , JOB_EFFSEQ , COMPANY , BUSINESS_UNIT , %TrimSubstr(SETID_LOCATION ,1 ,5) %Concat %TrimSubstr(LOCATION,1,10) , %TrimSubstr(SETID_DEPT,1,5) %Concat %TrimSubstr(DEPTID ,1 ,10) , %TrimSubstr(SETID_JOBCODE,1,5) %Concat %TrimSubstr(JOBCODE,1,6) , %TrimSubstr(SETID_SALARY,1,5) %Concat %TrimSubstr(SAL_ADMIN_PLAN,1,4) %Concat %TrimSubstr(GRADE,1,3) , POSITION_NBR , PRIMARY_INDICATOR , %TrimSubstr(SETID_LBR_AGRMNT ,1 ,5) %Concat %TrimSubstr(LABOR_AGREEMENT,1,6) %Concat %TrimSubstr(EMPL_CTG,1,6) , TC_HEAD_COUNT , TC_FTE , %TrimSubstr(SETID_LBR_AGRMNT ,1 ,5) %Concat %TrimSubstr(LABOR_AGREEMENT,1,6) FROM PS_TC_POPULATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Total Comp Plan ID |
| 2 | TC_PLAN_EFFDT |
Date(10) | DATE | Total Comp Plan Effective Date |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | THRU_DATE |
Date(10) | DATE | Thru Date |
| 7 | FROM_DATE | Date(10) | DATE | From Date |
| 8 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 9 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | TC_SETID_LOCATION | Character(15) | VARCHAR2(15) NOT NULL | Location |
| 13 | TC_SETID_DEPT | Character(15) | VARCHAR2(15) NOT NULL | Department ID |
| 14 | TC_SETID_JOBCODE | Character(11) | VARCHAR2(11) NOT NULL | Job Code |
| 15 | TC_SETID_SALPLAN | Character(12) | VARCHAR2(12) NOT NULL | Salary Plan and Step |
| 16 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 17 | PRIMARY_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Primary Indicator |
| 18 | TC_EMPL_CTG | Character(17) | VARCHAR2(17) NOT NULL | TC - Employee Categorization |
| 19 | TC_HEAD_COUNT | Number(6,0) | INTEGER NOT NULL | Head Count |
| 20 | TC_FTE | Number(15,6) | DECIMAL(14,6) NOT NULL | FTE |
| 21 | TC_SETID_LA | Character(15) | VARCHAR2(15) NOT NULL | Labor Agreement |