FPY_IDENTFOR_VW(SQL View) |
Index Back |
|---|---|
Identifier Format ViewIdentifier Format View |
| SELECT DISTINCT FPY_BUS_OBJ , (CASE FPY_BUS_OBJ WHEN 'POS' THEN 'Position Code~Effective Start Date' WHEN 'PER' THEN 'Person Number' WHEN 'ADD' THEN 'Person Number~Address Type~Effective Start Date' WHEN 'NAM' THEN 'Person Number~Name Type~Effective Start Date' WHEN 'EML' THEN 'Person Number~Email Type' WHEN 'LEG' THEN 'Person Number~Effective Start Date' WHEN 'NID' THEN 'Person Number~NID Type' WHEN 'PHN' THEN 'Person Number~Phone Type' WHEN 'JOB' THEN 'Person Number~Assignment Number~Effective Start Date~Effective Sequence' WHEN 'CMP' THEN 'Person Number~Assignment Number~Effective Start Date' WHEN 'BNS' THEN 'Run ID~Person Number~Assignment Number~Effective Start Date' WHEN 'JCI' THEN 'Person Number~Assignment Number' WHEN 'SCI' THEN 'Position' WHEN 'PCI' THEN 'Person Number' WHEN 'SCI' THEN 'Position' WHEN 'PCI' THEN 'Person Number' WHEN 'BUS' THEN 'Business Unit' WHEN 'DEP' THEN 'Organization Name' WHEN 'LOC' THEN 'Location Code' WHEN 'JCD' THEN 'Job Code' WHEN 'COM' THEN 'Legal Entitiy Name' WHEN 'DCI' THEN 'Organization name' WHEN 'LCI' THEN 'Location Code' WHEN 'OCI' THEN ' Job Code' WHEN 'CCI' THEN 'Legal Entitiy Name' WHEN 'ABS' THEN 'Person Number~Absence Person Entry ID~Start Date' END) , (CASE FPY_BUS_OBJ WHEN 'POS' THEN 'Position Number ~Effective Date' WHEN 'PER' THEN 'Employee ID' WHEN 'ADD' THEN 'Employee ID~Address Type~Effective Date' WHEN 'NAM' THEN 'Employee ID~Name Type~Effective Date' WHEN 'EML' THEN 'Employee ID~Email Type' WHEN 'LEG' THEN 'Employee ID~Effective Date' WHEN 'NID' THEN 'Employee ID~Name Type~Effective Date' WHEN 'PHN' THEN 'Employee ID~Phone Type' WHEN 'JOB' THEN 'Employee ID~Employee Record~Effective Date~Effective Sequence' WHEN 'CMP' THEN 'Employee ID~Employee Record~Effective Date~Effective Sequence' WHEN 'BNS' THEN 'Employee ID~Employee Record' WHEN 'JCI' THEN 'Employee ID~Employee Record' WHEN 'SCI' THEN 'Position Number' WHEN 'PCI' THEN 'Employee ID' WHEN 'BUS' THEN 'Business Unit' WHEN 'DEP' THEN 'SetID~Department~Effective Date' WHEN 'LOC' THEN 'SetID~Location~Effective Date' WHEN 'JCD' THEN 'SetID~Job Code~Effective Date' WHEN 'COM' THEN 'Company~Effective Date' WHEN 'DCI' THEN 'SetID~Department~Effective Date' WHEN 'LCI' THEN 'SetID~Location~Effective Date' WHEN 'OCI' THEN 'SetID~Job Code~Effective Date' WHEN 'CCI' THEN 'Company~Effective Date' WHEN 'ABS' THEN 'EmployeeID~Earnings Code~Absence Entry Date' END) FROM PS_FPY_ERROR_LOG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FPY_BUS_OBJ |
Character(3) | VARCHAR2(3) NOT NULL |
Business Object
ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position |
| 2 | FPY_IDENT_FORMAT | Character(80) | VARCHAR2(80) NOT NULL | Fusion Identifier Format |
| 3 | FPY_PSIDENT_FORMAT | Character(80) | VARCHAR2(80) NOT NULL | Peoplesoft Identifier Format |