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 |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/Assignment",
"title": "Assignment",
"type": "object",
"properties": {
"assignmentId": {
"type": "integer",
"description": "Assignment identifier",
"example": "500123"
},
"assignmentNumber": {
"type": "string",
"description": "Assignment number",
"example": "example_value"
},
"assignmentType": {
"type": "string",
"description": "Assignment type",
"enum": [
"E",
"C",
"A"
],
"example": "E"
},
"primaryFlag": {
"type": "string",
"description": "Whether this is the primary assignment",
"enum": [
"Y",
"N"
],
"example": "Y"
},
"jobId": {
"type": "integer",
"description": "Job identifier",
"example": "500123"
},
"jobName": {
"type": "string",
"description": "Job name",
"example": "example_value"
},
"positionId": {
"type": "integer",
"description": "Position identifier",
"example": "500123"
},
"positionName": {
"type": "string",
"description": "Position name",
"example": "example_value"
},
"gradeId": {
"type": "integer",
"description": "Grade identifier",
"example": "500123"
},
"gradeName": {
"type": "string",
"description": "Grade name",
"example": "example_value"
},
"organizationId": {
"type": "integer",
"description": "Organization identifier",
"example": "500123"
},
"organizationName": {
"type": "string",
"description": "Organization name",
"example": "example_value"
},
"locationId": {
"type": "integer",
"description": "Location identifier",
"example": "500123"
},
"locationCode": {
"type": "string",
"description": "Location code",
"example": "example_value"
},
"supervisorId": {
"type": "integer",
"description": "Supervisor person identifier",
"example": "500123"
},
"payrollId": {
"type": "integer",
"description": "Payroll identifier",
"example": "500123"
},
"employmentCategory": {
"type": "string",
"description": "Employment category",
"enum": [
"FR",
"FT",
"PR",
"PT"
],
"example": "FR"
},
"normalHours": {
"type": "number",
"format": "double",
"description": "Normal working hours",
"example": 42.5
},
"frequency": {
"type": "string",
"description": "Hours frequency",
"enum": [
"D",
"W",
"M",
"Y"
],
"example": "D"
},
"effectiveStartDate": {
"type": "string",
"format": "date",
"example": "2026-01-15"
},
"effectiveEndDate": {
"type": "string",
"format": "date",
"example": "2026-01-15"
}
}
}