Oracle E-Business Suite · Schema
Assignment
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| assignmentId | integer | Assignment identifier |
| assignmentNumber | string | Assignment number |
| assignmentType | string | Assignment type |
| primaryFlag | string | Whether this is the primary assignment |
| jobId | integer | Job identifier |
| jobName | string | Job name |
| positionId | integer | Position identifier |
| positionName | string | Position name |
| gradeId | integer | Grade identifier |
| gradeName | string | Grade name |
| organizationId | integer | Organization identifier |
| organizationName | string | Organization name |
| locationId | integer | Location identifier |
| locationCode | string | Location code |
| supervisorId | integer | Supervisor person identifier |
| payrollId | integer | Payroll identifier |
| employmentCategory | string | Employment category |
| normalHours | number | Normal working hours |
| frequency | string | Hours frequency |
| effectiveStartDate | string | |
| effectiveEndDate | string |